Access Convert a decimal time to hours and minutes

[meisha]

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]

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 ":"

 

[AmjiBhai]

A=10.55
a_txt=format(a,"00.00")
a_txt=replace(a_txt,".",":")
a_time=timevalue(a_txt,... whatever