converting time to decimal

J

JE McGimpsey

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
 
G

Guest

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...
 
G

Guest

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

Jay

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.
 
J

JE McGimpsey

And nothing will - you have to first perform the calculation I gave you,
"then reformat the cell".
 

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

Excel does not accept text format! 0
HOW TO INPUT MONTHLY ACCUMULATED SALARY IN MS PROJECT? 0
Work Budget Salary vs Real Time Salary 0
Excel is too complicated for me 4
how to convert time to decimal format 4
Calculating payroll cost 1
I need calculated time in a "real number" format 2
Gross up payroll calculation 0

Top