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 ...
You're right I didn't realize that: =TEXT(D3-C3,"hh:mm"). how should it be written?
on cell Ctrl+1 and apply custom format as
- Using that format for the sum, the formula must be revised as:
=SUMPRODUCT(—A1:A7)
It returns 36:34.
