Divide by 24 then format in the Time style of your choice.

A1 = 6.12

=A1/24

--
Biff
Microsoft Excel MVP


"GAIDEN" wrote in message
...
how do i convert 6.12 hours to its time equivalent 06:07:12? i tried
custom
formatting using h:mm:ss but i get 2:52:48.