Aug 01 2021 11:30 AM
Hi all, I need some advice on how to solve this problem please: I’m trying to find a formula that will auto sum a works timesheet where on a Saturday the overtime rates are different from 00:00 (Friday/Saturday midnight) to 12:00 (Saturday lunchtime), then change to a different rate after lunch time.
So for example; if I start work at 09:00 and finish at 16:00:
All I want to do is input start and finish times (A2 & B2), then have Excel auto populate the cells C2, D2,E2, F2 and G2.
If no hours worked then to show a blank cell.
I can sort out the currency formulas, but I’m getting stuck when calculating the hours in C2 & D2.
Any ideas???
Thanks in advance!
Aug 01 2021 11:59 AM
SolutionSee the attached sample workbook.
Aug 01 2021 12:50 PM
Aug 01 2021 01:41 PM
See the attached. If it gets more complicated than this, it would better to change the setup a bit.
Aug 01 2021 11:59 AM
Solution