G GAIDEN Nov 17, 2008 #1 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.
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 T. Valko Nov 17, 2008 #2 Divide by 24 then format in the Time style of your choice. A1 = 6.12 =A1/24
G GAIDEN Nov 17, 2008 #4 thanks, that worked Sheeloo said: Divide by 24 and format as h:mm:ss Click to expand...
