Sum between times

[6467100000]

Hi,

I hope someone can help.

I am building an overtime calculator and I need some help.

Cell A1 has the start time and Cell A2 has the finish time, I am calculating the total hours worked using the following formula which works fine.
=IF(A1>A2,A2+1-A1,A2-A1)*24

Seperatley I need to count the number of hours worked within the hours of 08:00 and 20:00 so that I can calculate overtime a sociable rate and then the number of ours worked between 20:00 and 08:00 to be able to calculate the overtime at a unsociable rate.

Could someone explain how I calcualte the sociable and unsociable hours worked?

Many thanks

 

[AlphaFrog]

Excel Workbook
	A	B	C	D	E
1	9:00 AM		Total Hrs	Hrs within 8:00 to 20:00	Hrs within 20:00 to 8:00
2	9:00 PM		12	11	1
Sheet

 

[6467100000]

Thats fantastic, thank you.

Also, how would i do the same to count the number of ours between 22:00 and 06:00 as I need to apply a additional £5 per hour payment for hours worked between 22:00 and 06:00.

Many thanks

 

[6467100000]

Any ideas?

 

[AlphaFrog]

Excel Workbook
	A	B	C	D	E	F
1	9:00 PM		Total Hrs	Hrs within 8:00 to 20:00	Hrs within 20:00 to 8:00	Hrs within 22:00 to 6:00
2	9:00 AM		12	1	11	8
Sheet

 

[6467100000]

Thats perfect, thank you!!