How do I calculate the number of night hours worked

**Somlal22** · 08-17-2012, 06:16 AM

Hi

Can some please help me to calculate the number of hours worked between 18:00 and 06:00.
Attached is a copy of what I have so far, I have formulas in place to calculate total hours worked, less lunch, regular and overtime hours. But I'm still calculating night hours manually. What is the formula to calculate this.

**Pete_UK** · 08-17-2012, 06:38 AM

Try this in K9:

=(F9+E9-A9-B9-D9+C9)*24

Hope this helps.

Pete

**daddylonglegs** · 08-17-2012, 07:09 AM

I used this formula in K4 copied down

=IF(COUNT(B4:E4)=4,H4-(B4>C4)*12-MEDIAN(C4*24,6,18)+MEDIAN(B4*24,6,18)-(D4>E4)*12-MEDIAN(E4*24,6,18)+MEDIAN(D4*24,6,18),"")