Counting different workinghour types

[Guest]

I have a problem
Itry to calculate with excel how much night hours evening hours i have done
example
Working hours are starting time in c7 15:30 and end time D7 23:59 and if i
get extra pay between 18:00 and 21:00 how can i calculate these hours in
evening bonuses

 

[Bernard Liengme]

Total hours worked (formula in E7) =D7-C7 Hours outside evening
time (formula in F7) =(TIME(18,0,0)-C7)+(D7-TIME(21,0,0))
Hours during evening time (formula in G7) =E7-F7
With 15:30 and 23:59, we get
8:29
5:29
3:00
Or one formula
=(D7-C7)-((TIME(18,0,0)-C7)+(D7-TIME(21,0,0)))
best wishes

 

[Guest]

Thank you for your solution, but when I tryed it in hours C7 0:00 D7 19:30
it gave me answer 3:00 and it should be 1:30 there is somthing i missed when
i tryed to alter the formula so it would calculate above mentioned problem.