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

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
 
M

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
 
D

Dave

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...
 
J

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
Click to expand...

Try something like

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Calculated minus breaks & lunch 2
Access Convert a decimal time to hours and minutes 2
Converting standard time to decimal time 2
Case Statement Help 2
changing the decimal to hex 5
Formatting Result of Date AND Time Difference 3
Convert Decimal Minutes to Hours-Minutes-Seconds 3
Decimal time 2

Top