convert decimal hours to HMS?

  • Thread starter Thread starter Everett Joline
  • Start date Start date
Divide the decimal hours by 24 and format the cell from hh:mm:ss.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Hi E-Jo

In general, divide by 24 and format as hh:mm. But "decimal hours" come in
lots of flavors, like 1045, 10.45, 10.75 and 1075, all representing 10:45,
so you may have to adjust a little -or maybe a lot. See Chip Pearson's page
http://www.cpearson.com/excel/datetime.htm for some theory on this.

HTH. Best wishes Harald
 
Thanks Chip and Harold for your quick response. I guess the secret is to
divide by 24
to get it into days first, and then convert that.
E-Jo
 
E-Jo,

Times are stored as a fraction of a 24 hour day (06:00 = 0.25,
12:00 = 0.5, 18:00 = 0.75, etc), so if you have a number of
hours, such as 14.5, dividing that by 24 converts it to an Excel
time value.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 

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

Convert date/time value to decimal hours 6
Access Convert a decimal time to hours and minutes 2
Convert Date & hour to decimal 4
Converting standard time to decimal time 2
Excel How To Convert Decimal To Inches 2
How to convert Hours Minute Second format number to decimal forma. 1
Eliminate Decimals 4
How to convert decimal year to date format in excel 2

Back
Top