[rivertech233]

I am trying to write a conditional formula using using times with the following parameters:

cell A1 7:30 AM - cell B1 5:30 PM - cell C1 =(B1-A1)*24

This formula will calculate the hours (10) between 7:30am and 5:30pm, which for the purpose of the exercise are classified as standard hours. Any hours outside these hours are classified as non-standard. I need a conditional formula (for cell C1 or D1) to calculate non-standard hours (cell D1) either side of the standard hours as required.

If anyone is wondering, my wife does childcare and I am trying to automate her daily calculations. This one has me stumped.

Thank you in advance.

[Aj_old]

Hi!
Something like the attached file will be fine?