converting time to decimal

  • Thread starter Thread starter jean
  • Start date Start date
XL stores times as fractional days (e.g., 3:00 = 0.125). To convert to
decimal hours, multiply by 24:

A1: 03:30
A2; =A1*24 ===> 3.5
 
But if I do that it adds AM or PM
-----Original Message-----
XL stores times as fractional days (e.g., 3:00 = 0.125). To convert to
decimal hours, multiply by 24:

A1: 03:30
A2; =A1*24 ===> 3.5



.
Click to expand...
 
You're coming with great answers--too bad I've already
tried that! Nothing seems to convert from 8:45 to 8.75.
 
wrote:
You're coming with great answers--too bad I've already
tried that! Nothing seems to convert from 8:45 to 8.75.
Click to expand...

Example:

A1: 01/01/2004 2:00:00 AM

B1: 01/01/2004 10:45:00 AM

C1: =24*(B1-A1)
Formatted as a number with 2 decimal places.

Seems to work.
 
And nothing will - you have to first perform the calculation I gave you,
"then reformat the cell".
 
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

Convert Decimal fractions to binary and vice versa 1
Calculating payroll cost 1
Access Convert a decimal time to hours and minutes 2
how to convert time to decimal format 4
I need calculated time in a "real number" format 2
Excel How To Convert Decimal To Inches 2
convert decimal numbers to a fraction of an hour for payroll hour 4
Convert decimal days to hours and minutes 2

Back
Top