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,406
Reaction score
1,501
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 ":"
 
Ad

Advertisements

Joined
Feb 21, 2018
Messages
107
Reaction score
45
A=10.55
a_txt=format(a,"00.00")
a_txt=replace(a_txt,".",":")
a_time=timevalue(a_txt,... whatever
 

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