Excel Timesheet Formula for Excel

[chrissie]

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!

 

[chrissie]

Just to clarify - I don't need to calculate my own pay, just the hours within specific time brackets. Thankyou!