Hi,
Populating a timesheet in excel thats works standard and normal hours from a daily hour i.e. 12 hours worked, 7.2 hours standard anything over is overtime.
Currently using the following formulaes:
STANDARD HOURS =MIN(Sheet1!G13,7.2)
OVERTIME HOURS =MAX(0,Sheet1!G13-7.2)
Overtime seems to work fine, but I am finding that if a cell has no data entered (as they haven't worked that day) the standard hours formula is still returning 7.2
Is there anyway I can have it that if G13 was blank the formula would return 0?
Thanks!
Bookmarks