Converting Times into Numeric

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.

bmils said:
How do I convert a 24 hour clock into a number...for instance...I am
Click to expand...
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?
 
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
 
Back
Top