Time to Decimals 1

[JJOHNS]

Here's the problem: I have a start time and an end time, something like this:

Start: 3:32:16
End: 6:02:22

I need to be able to represent the total time as a decimal, 2.5. Does anyone know how to do this?

 

[beetee]

([EndTime] - [StartTime]) * 24
should do the trick

Access dates are stored as floating point numbers. The 'whole' part is the number of days, the fractional part is the portion of a day. Multiplying a date by 24 converts it into hours.

 

[JJOHNS]

Thanks a bunch beetee. I wasted a lot of hours trying to figure that out. Works great.

 

[sk31]

Thanks beetee this was very helpful.