Thread: Help with calc time in certain periods

Hi, my first post here - hope you guys can help me as I'm really lost here.

I need to make a excel sheet where I can keep track of a how many hours(or mins) a person is at work during a 24h day/week, with different saleries depending on different times of the day and if it's weekend or not.

The tricky part for me, is that I need to keep track of how many hours a person is working between 06:00-17:59 and how many are not (ie. between 18:00-05:59).
Also, I need to keep in take into account if it's between 06:00 saturday morning to 05:59 monday morning, then it needs to be calculated seperately as well. If this can be solved with a dropdown to indicate if it's weekend or not, that's fine with me

I've tried to do this with a =IF(AND statement, but I'm not a programmer and I'm completly at a loss here

So far what I came up with is a statement that checks if the meeting time is between 06:00 and 17:59 - but it's like I need a whole different level to take everything into account.

=IF(AND(B5>=0,25;B5<0,75);(C5-B5)+(("23:59"-D5)+"00:01")+((E5-"00:01")+"00:01");0)
(The 0,25 I found equals 06:00 and 0,75 equals 18:00)

Are there any who can help me?

Best regards,
Casper