Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Calculating time in Excel
Name: Sch1man Date: December 19, 2003 at 04:05:34 Pacific OS: w2000 CPU/Ram: 1.8ghz
Comment:
In cell A2 I have my start time: eg 5:30 In cell A3 I have my stop time: eg 4:30 What is the formula I need to calculate the time I've worked?
Name: safeTsurfa Date: December 19, 2003 at 06:11:22 Pacific
Reply:
Simple subtraction of A3-A2, and format the result cell as [h]:mm display. Remember, time is a human creation, but to the computer it is just a decimal number resolved to many places.
0
Response Number 2
Name: chnos Date: December 19, 2003 at 06:22:55 Pacific
Reply:
test if a3>a2 and next a3-a2; If u've got to place time >24 hours, u've got to decomposite with the date (see functiun help "date"), because this formula takes no more than 24 hours....
0
Response Number 3
Name: safeTsurfa Date: December 21, 2003 at 11:12:32 Pacific
Reply:
The setting [h]:mm allows more than the 24 hour day, which is why I suggested it. It works well with a timesheet for calculating hours worked per week.
0
Response Number 4
Name: chnos Date: December 21, 2003 at 23:11:46 Pacific
Reply:
Yes safetSurfa, u're right. I didn't verify it before i send my answer. Thanks for the precision, and merryXmas
Summary: I am using Excel to help me record responses to some performance tests I give. In doing this, I have to record start and stop times, in seconds, then calculated the differences. To date, I have ente...
Summary: I have a problem calculating time in Excel. For example, in column A the time is 30:20(30 hours and 20 minutes), how can I turn the minutes into hours in Column B and get the answer of 30.33. If the h...
Summary: I'm trying to add time entries formatted as HH:MM in Excel including some negative values used as time corrections. There are formulas that convert time to decimals, but they fail on the negative val...
0 
