Calculating work hours between two dates HELP!

[Dinahpey]

Start Date: 6-july 2019 8:00
End Date: 8-july 2019 10:00

I need formula calcuting work hours between two dates excluding 1 day off, lunch break, and breaks.
my work starts at 8am-5pm only
my 1st break is 10:00-10:15
my lunch break is 12:00-13:00
my 2nd break is 15:00-15:15
day off is sunday only.

THANKS!

[Pepe Le Mokko]

Solved many times on this forum and others. Please search the forum first

[Dinahpey]

Mine is different. Please help 😥

[AliGW]

Welcome to the forum!

Pepe appears to have forgotten to provide a link to help you. Here's one of the threads he was thinking of: https://www.excelforum.com/excel-for...-holidays.html

It is extremely similar to your own request and should require only a little adaptation to suit your need. Have a go and ask again if you can't quite work it out.