Hi All,
I'm in the midst of preparing a time sheet & need some assistance when multiple if conditions are involved;
i.e if an employee from X dept if roaster on them for few days of the week normal working hour are xxhrs & the remaining is overtime
Please find attached my sample spreadsheet with my conditions laid . Appreciate if someone could help me build this multiple conditions in a formula
Thanks in advance
John
Bookmarks