Convert Time to Decimal

[V Terry]

I'm trying to convert 02:15:00 or 15:00 into a decimal,
such as 2.25 or 0.25 any ideas?

Unfortunately the data is as above, not consistent in the
number of places, not always hours and minutes, just
minutes if less than an hour.

Thank you!

 

[V Terry]

These are calculated elapsed times in hours and minutes,
not time of day.

 

[fredg]

I'm trying to convert 02:15:00 or 15:00 into a decimal,
such as 2.25 or 0.25 any ideas?

Unfortunately the data is as above, not consistent in the
number of places, not always hours and minutes, just
minutes if less than an hour.

Thank you!

DecimalTimeatePart("h",[TimeField]) &
Format(DatePart("n",[TimeField])/60,".00")

 

[Guest]

Works like a charm! I do have a problem if the original
time is over 24 hours, is there a variation for that
situation?

Thanks so much for passing on your knowledge!

Vickie Terry

-----Original Message-----

I'm trying to convert 02:15:00 or 15:00 into a decimal,
such as 2.25 or 0.25 any ideas?

Unfortunately the data is as above, not consistent in the
number of places, not always hours and minutes, just
minutes if less than an hour.

Thank you!

DecimalTimeatePart("h",[TimeField]) &
Format(DatePart("n",[TimeField])/60,".00")
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.