Access Convert a decimal time to hours and minutes


Joined
Feb 22, 2019
Messages
1
Reaction score
0
i have the decimal value of 10.55 (10 hours and 55 mins) should convert to 10:55

I've already used Format( 10.55 / 24.0, "hh:nn:ss" )

and i got 10: 33: 00?

what should i do?

btw, I'm using Ms Access.

Any suggestions would be greatly appreciated!!

Thanks!
 

Becky

Webmistress
Administrator
Joined
Mar 25, 2003
Messages
7,350
Reaction score
1,474
You are trying to convert a decimal to hh:mm but it is not a decimal despite the syntax. Given that the issue seems to be a syntax problem, could you do a find and replace for that group of data? ie find the instances of "." and replace them with ":"
 

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

Top