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

  • Thread starter Thread starter Dave
  • Start date Start date
D

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
 
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
 
Thnaks that works

Dave

Michel Walsh said:
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
Click to expand...
 
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
Click to expand...

Try something like

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