FoxPro Help and Support - URGENT! HOURS DEDUCTION

Author

URGENT! HOURS DEDUCTION

mun

2005-12-07, 3:41 am

Dear sir/madam,
i face a datetime deduction problems.
for example:
?CTOT('18:30:00') - CTOT('15:00:00') // output = 12600
so, how to convert back 1800 to hours? like display 3:30 hours

waiting for your reply. Thanks!

regards,
mun

Jay B

2005-12-07, 3:41 am

divide by 60 twice, since 60 mins in a hour, and 60 secs in a min
?12600/60/60=3.5
then format into hours:mins

mun wrote:

> Dear sir/madam,
> i face a datetime deduction problems.
> for example:
> ?CTOT('18:30:00') - CTOT('15:00:00') // output = 12600
> so, how to convert back 1800 to hours? like display 3:30 hours
>
> waiting for your reply. Thanks!
>
> regards,
> mun
>
>
>

Dennis Longfellow

2005-12-07, 11:24 am

Just a little refinement to what Jay told you to do:

?? ALLTRIM(STR(INT(1260
0/60/60)))+":" +ALLTRIM(STR(INT(MOD
(12600,60*60)/60)))

Dennis Longfellow

"Jay B" <jayb@audiman.net> wrote in message
news:3hxlf.3542$Kf4.3192@fe08.lga...[color=darkred]
> divide by 60 twice, since 60 mins in a hour, and 60 secs in a min
> ?12600/60/60=3.5
> then format into hours:mins
>
> mun wrote:
>

Anders

2005-12-08, 7:25 am

? TTOC(DATETIME(2000,1
,1,0,0,0)+12600,2),'
hours'

-Anders

"mun" <mun@discussions.microsoft.com> skrev i meddelandet
news:54D12F1A-09D8-4385-8083- E21FF7DD0ED0@microso
ft.com...
> Dear sir/madam,
> i face a datetime deduction problems.
> for example:
> ?CTOT('18:30:00') - CTOT('15:00:00') // output = 12600
> so, how to convert back 1800 to hours? like display 3:30 hours
>
> waiting for your reply. Thanks!
>
> regards,
> mun
>
>
>

mun

2005-12-08, 7:25 am

hi, Anders! Thanks for your help!

"Anders" wrote:

> ? TTOC(DATETIME(2000,1
,1,0,0,0)+12600,2),'
hours'
>
> -Anders
>
> "mun" <mun@discussions.microsoft.com> skrev i meddelandet
> news:54D12F1A-09D8-4385-8083- E21FF7DD0ED0@microso
ft.com...
>
>
>

Sponsored Links