redspanna
Well-known Member
- Joined
- Jul 27, 2005
- Messages
- 1,602
- Office Version
- 365
- Platform
- Windows
Hi all
I'm simply trying to gain the total hours worked for a range (in column B) only if the value in column A is populated with a N
So on this example the formula returns the correct value of 19:09.
However if I add another row to the range I get a wrong returned value
The value returned now is 01:31, when it should be 25:31
All time columns are formatted with H:MM, so not sure what's going wrong
Sometime the simple things annoy the heck out of me and any help appreciated
I'm simply trying to gain the total hours worked for a range (in column B) only if the value in column A is populated with a N
N | 05:30 | =SUMIF(A1:A4,"N",B1:B4) |
05:25 | ||
N | 06:31 | |
N | 07:08 |
So on this example the formula returns the correct value of 19:09.
However if I add another row to the range I get a wrong returned value
N | 05:30 | =SUMIF(A1:A5,"N",B1:B5) |
05:25 | ||
N | 06:31 | |
N | 07:08 | |
N | 06:22 |
The value returned now is 01:31, when it should be 25:31
All time columns are formatted with H:MM, so not sure what's going wrong
Sometime the simple things annoy the heck out of me and any help appreciated