Hi guys
I have a timesheet that takes forever to fill out and I'm looking for a formula that will save me some time and manual input.
Let's say I do a shift from 0600 - 1600. (I get paid for my lunch break so that's not an issue.) That is 10 hours pay. But I need to calculate within that shift the amount of hours between 0600 and 0730 as that is a different pay level.
Then I need to calculate hours between 1900 and 2200 as that is a different pay level. (Obviously zero for the example I provided).
Then I need to calculate the number of ordinary hours between 0730 and 1900.
For every shift, for every day (and sometimes multiple shifts per day).
My problem is that I have a VERY basic understanding of excel formulas and I am not very good at counting. Please help!
I have a timesheet that takes forever to fill out and I'm looking for a formula that will save me some time and manual input.
Let's say I do a shift from 0600 - 1600. (I get paid for my lunch break so that's not an issue.) That is 10 hours pay. But I need to calculate within that shift the amount of hours between 0600 and 0730 as that is a different pay level.
Then I need to calculate hours between 1900 and 2200 as that is a different pay level. (Obviously zero for the example I provided).
Then I need to calculate the number of ordinary hours between 0730 and 1900.
For every shift, for every day (and sometimes multiple shifts per day).
My problem is that I have a VERY basic understanding of excel formulas and I am not very good at counting. Please help!