I have a timesheet for work where I put total hours in A1.Then i need a formula in B1 to calculate ordinary hours i.e 8.
And in C1 I will have 50% overtime i.e hours between 8-12.And at last in D1 all 100% overtime hours over 12.
Thanks for any help.
And in C1 I will have 50% overtime i.e hours between 8-12.And at last in D1 all 100% overtime hours over 12.
Thanks for any help.