Time to number 1

[Ptrif]

Is it possible to convert an entered time such as 10:30 <--that time meaning 10 hours and 30 mintutes, to 10.5?? any help is apprciated.

 

[jrbarnett]

Hi,

Yes. Use the following formula to calculate the output:

TheHour = Hour (TimeField)
TheMinute = Minute (TimeField) / 60
Output = str(TheHour) & &quot;.&quot; & str(TheMinute)

John

 

[PaulBricker]

I think you can use this also
TimeField * 24
10:30 return 10.5


Paul

 

[dhookom]

Paul is correct (and gets a star). There is no need to convert time since it is stored in a floating point numeric value that is equivalent to a number of days and percents of days. Since there are 24 hours in a day, multiply your time value by 24 to get the number of hours.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.