minutes in hours

[phpatrick]

perhaps a silly one,

if the value of a field mentioned 01:00 or 01:22 (short time notition) how cen I get the number of minutes (* 60 ?)

 

[Golom]

? Minute(TimeValue("01:22")) + 60 * Hour(TimeValue("01:22"))
 82

 

[PHV]

If the Field is defined as DateTime:
NumOfMinutes = 1440 * yourTimeField

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886