I need to convert a decimal time to hours and minutes, is there a

[Dave]

I have a decimal value into hours and minutes.

The decimal value of 1.09 should equal 1:05

Is there a function to do this?

Thanks

 

[Michel Walsh]

If it is less than 24 hours (and greater than 0), you can try:

Format( x / 24.0, "hh:nn:ss")


such as


? Format( 1.09 / 24.0, "hh:nn:ss" )




not that it is nn, not mm, since mm is for Month, not miNute




Vanderghast, Access MVP

 

[Dave]

Thnaks that works

Dave

If it is less than 24 hours (and greater than 0), you can try:

Format( x / 24.0, "hh:nn:ss")


such as


? Format( 1.09 / 24.0, "hh:nn:ss" )




not that it is nn, not mm, since mm is for Month, not miNute




Vanderghast, Access MVP

 

[John W. Vinson]

I have a decimal value into hours and minutes.

The decimal value of 1.09 should equal 1:05

Is there a function to do this?

Thanks

Try something like

CInt([yourfield]) & ":" & Format([yourfield] * 60 MOD 60, "00")