Chris Dyke
New Member
- Joined
- Jan 25, 2017
- Messages
- 8
Hi there,
I have a sheet that shows the number of hours above or below a standard working day a person has worked. I need to then sum these. The formula I have (column R) is fine if the outcome is positive (row 3) but not when negative (row 4). Any ideas please?
https://drive.google.com/open?id=1BHEQxUGrO2R3nvxr_4m1LBOL7k2sPIhj
Thanks in advance,
Chris
I have a sheet that shows the number of hours above or below a standard working day a person has worked. I need to then sum these. The formula I have (column R) is fine if the outcome is positive (row 3) but not when negative (row 4). Any ideas please?
https://drive.google.com/open?id=1BHEQxUGrO2R3nvxr_4m1LBOL7k2sPIhj
Thanks in advance,
Chris