time conversion

[GAIDEN]

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.

 

[T. Valko]

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

A1 = 6.12

=A1/24

 

[Sheeloo]

Divide by 24 and format as h:mm:ss

 

[GAIDEN]

thanks, that worked

Divide by 24 and format as h:mm:ss