CountTime Between Ranges

[6467100000]

Hi,

I an writng an overtime calculator and need some help.

The start time of the shift is in A1 and the finish time in B1.

C1 calculates the total hours worked in a shift using the following
=IF(A1>B1,B1+1-A1,B1-A1)*24

In addition to the above, I need to be able to calulate the number of hours worked between 22:00 and 06:00 so that I can apply a unsociable working payment of £5 per hour.

How do I calculate the number of hours worked between the range of 22:00 and 06:00 between A1 and B1?

Many thanks

 

[Toonies]

Hi here is a Timesheet, if you need any help just ask

http://www.mediafire.com/?u9duuwrus8p34hq

Cheers

Toonies

 

[6467100000]

Thanks for your response but i cant see an equivalent formula in your sheet??

 

[Toonies]

Hi simply adapt the Timesheet to your requirements, simply unprotect the sheet to see the formulas.

It is already set for the time frame 22:00 to 6:00 just chage the cost rate on the pay sheet

Toonies