pruedelicious
New Member
Hi there
Is there any ideas on formulas to help me streamline/calculate my gross pay per work shift when each shift might have 3 different penalty rates depending on the time of the shift e.g. Sunday night shift starting at 2300 and ending 0700 on Monday morning encompasses 3 pay scales, one for 11pm - midnight on Sunday, one for midnight to 6am Monday and one for 6am - 7am Monday morning.
Can excel look up a date and time (maybe start time of the shift since each is 8 hours) and then determine which pay scale should be applied for the relevant times within that shift?
Hope that makes sense? Any help would be sooooooo appreciated
Is there any ideas on formulas to help me streamline/calculate my gross pay per work shift when each shift might have 3 different penalty rates depending on the time of the shift e.g. Sunday night shift starting at 2300 and ending 0700 on Monday morning encompasses 3 pay scales, one for 11pm - midnight on Sunday, one for midnight to 6am Monday and one for 6am - 7am Monday morning.
Can excel look up a date and time (maybe start time of the shift since each is 8 hours) and then determine which pay scale should be applied for the relevant times within that shift?
Hope that makes sense? Any help would be sooooooo appreciated