Subtract start time from end time - Need result as fraction of an hour

[projecttoday]

Is there any way to get a calculated time in fractions of an hour? Right now I'm using

DateDiff("h",[starttime],[endtime]))

but if the time between starttime and endtime is 6 and 1/2 hours it shows on the report as 6. (General Number/Auto decimals). When I change the format of the fields to Fixed with 2 decimal places it shows as 6.00.

Robert

 

[Remou]

You can use n to get minutes:

DateDiff("n",[starttime],[endtime]))

http://lessthandot.com

 

[SkipVought]

Hi,

faq68-5827.

Time can be displayed to the nearest tenth of a second.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[PHV]

DateDiff("n", [starttime], [endtime])) / 60

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PHV]

OOps, sorry for the typo:
DateDiff("n", [starttime], [endtime]) / 60

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[strongm]

Or

(endtime - starttime)/4.16666666666667E-02

;-)

 

[PHV]

Or
(endtime - starttime) * 24

 

[projecttoday]

Thanks to all.