time conversion - minutes to hours?

[s0rtd]

hi guys,

i have a field which holds a time, the problem is the time is in minutes such as: 131 minutes (stored as a plain old number)

is there a way to convert that into a nice format such as 02:11:00

hours minutes seconds or something better than 131 minutes?

cheers

 

[R. Hicks]

To to this at form level directly in a control on a form ... use:

= Format([MinutesField]\60,"00") & ":" & Format([MinutesField] Mod 60,"00")
"MinutesField" should be the name of your field that contains the numeric minutes value.

If you want to do this at query level .. create a "field expression ....
Here is an example:

MyOutput: Format([MinutesField]\60,"00") & ":" & Format([MinutesField] Mod 60,"00")
Again ... "MinutesField" should be the name of your field that contains the numeric minutes value.

HTH
RDH

 

[s0rtd]

cheers, i didnt think it was possible!

thanks heaps

 

[R. Hicks]

No problem ..... You are Welcome ...

RDH