J
jean
Convert hours worked to a decimal to calculate payroll?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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
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
.
J
JE McGimpsey
Then reformat the cell...
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.
tried that! Nothing seems to convert from 8:45 to 8.75.
J
Jay
wrote:
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.
You're coming with great answers--too bad I've already
tried that! Nothing seems to convert from 8:45 to 8.75.
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".
"then reformat the cell".