Forum Discussion
formula to calculate total time worked in a week.
Hello, I'm trying to write a formula to calculate how many hours were worked during the a week. I either get an "value" message or 00:00. Can someone help me. 07:17 01:05 06:59 04:56 ...
Assuming your addends are in A1:A7, the formula for total hours is:
=SUMPRODUCT(HOUR(A1:A7)+(MINUTE(A1:A7)/60))
=SUMPRODUCT(HOUR(A1:A7)+(MINUTE(A1:A7)/60))
formula almost works, it did total to 13:36. when done on a calculator, it amounts to 35:15. it seems we're almost there.
- Using my formula, the sum, in general format, 36.57 hours.
