Converting Times into Numeric

[bmils]

How do I convert a 24 hour clock into a number...for instance...I am entering in a start time of 15:00 and an end time of 16:30...The difference that I am calculating is 1:30...how do i convert this into 1.5 hours?

Thanks in advance

 

[Allen Browne]

Type this into the Field row of a query:
Hours: DateDiff("n", [Startime], [Endtime]) / 60

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

How do I convert a 24 hour clock into a number...for instance...I am

entering in a start time of 15:00 and an end time of 16:30...The difference
that I am calculating is 1:30...how do i convert this into 1.5 hours?

 

[Bruce M. Thompson]

How do I convert a 24 hour clock into a number...for instance...I am entering
in a start time of 15:00 and an end time of 16:30...The difference that I am
calculating is 1:30...how do i convert this into 1.5 hours?

From the debug window:

? (timevalue("16:30")-timevalue("15:00"))*24
1.5