time conversion

  • Thread starter Thread starter GAIDEN
  • Start date Start date
G

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.
 
Divide by 24 then format in the Time style of your choice.

A1 = 6.12

=A1/24
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Difference between two date/time values 5
Lookup 15
Subtracting time...again 2
Converting time to decimal format 17
Calc minutes and seconds difference 15
how do i convert data with miliseconds to just h:mm:ss 5
Averaging times that are not in a range 3
Excel Convert Datetime Stamp to HH and MM Worked 7

Back
Top