Covert Integer to Number

[rustyfishbones]

Hi All,

I have a number 3.75, I want to convert this to a time

So my answer should be 03:45.

Regards

Alan

[sunny_talwar · Accepted solution]

Try this

=Time#(Floor(3.75) & ':' & Frac(3.75)*60, 'h:mm')

[shiveshsingh]

Try this

=Floor(3.75) &':' & Frac(3.75)*60

[MarcoWedel]

another solution might be

=Time(3.75/24,'hh:mm')

hope this helps

regards

Marco