Time Conversion

[Guest]

I have a field with and interger data type such as 750 that represents the
number of minutes since midnight. I need to convert this to actual time such
as 11:30 am in a query or in a module.

Any thoughts?

Many thanks if you can help!

 

[Brendan Reynolds]

Just divide by 1440 ...

? format(750/1440,"Long Time")
12:30:00

 

[onedaywhen]

Just divide by 1440 ...

? format(750/1440,"Long Time")
12:30:00

Alternatively:

? Date() + TimeSerial(0, 0, 750)

Jamie.

--

 

[Van T. Dinh]

I guess you meant

TimeSerial(0,750,0)

 

[onedaywhen]

I guess you meant

TimeSerial(0,750,0)

Good catch. Thanks,

Jamie.

--