I have been woring on automating a timesheet and have run into a problem on the final step of adding up the hours per day to return a total hours worked per 2 week period. The sheet is set up as follows;
A10=AM Time In (h:mm AM/PM format)
A11=AM Time Out (h:mm AM/PM format)
A12=PM Time In (h:mm AM/PM format)
A13=PM Time Out (h:mm AM/PM format)
A14=Total Hours Worked (h:mm format)
Q14= Sum (b14:q14) (h:mm format)
The calculation formula is a simple sum(b14:q14) formula and it works great, until the total hours summed becomes greater than 24. At that point the total returns to 0 and goes from there. For example, if the total hours worked is 23, no problem, 23 is returned as the sum. However, if the total hours worked is 28, the formula returns 4. When I highlight the entire row to be summed, the quick sum feature returns the correct sum, but I can't get the formula to work properly. Any ideas? Thanks in advance.
A10=AM Time In (h:mm AM/PM format)
A11=AM Time Out (h:mm AM/PM format)
A12=PM Time In (h:mm AM/PM format)
A13=PM Time Out (h:mm AM/PM format)
A14=Total Hours Worked (h:mm format)
Q14= Sum (b14:q14) (h:mm format)
The calculation formula is a simple sum(b14:q14) formula and it works great, until the total hours summed becomes greater than 24. At that point the total returns to 0 and goes from there. For example, if the total hours worked is 23, no problem, 23 is returned as the sum. However, if the total hours worked is 28, the formula returns 4. When I highlight the entire row to be summed, the quick sum feature returns the correct sum, but I can't get the formula to work properly. Any ideas? Thanks in advance.