Access Convert a decimal time to hours and minutes

M

meisha

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!
 
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 ":"
 
A=10.55
a_txt=format(a,"00.00")
a_txt=replace(a_txt,".",":")
a_time=timevalue(a_txt,... whatever
 
Back
Top