Calculate machine hours excluding weekends or non-operational hours

[salinnn]

Hi,

I am having a hard time figuring out a formula in this case. Here, 29th October is a Friday and 01st November is a Monday. Our Machine stops operating at 10:30pm on Friday and starts on 31st October Sunday Night 9:30pm. I need some help to figure this out. Time between pan loads will be difference between the current product and last one. So that's easy, just need help with total time when there is a weekend or a holiday. Please see attached screenshot, I downloaded XL2BB but it wouldn't load so can't use it.

 

[earthworm]

You cant calculate the days based on timing .

 

[salinnn]

You cant calculate the days based on timing .

I don't think that's true as days are based on hours as well. Anyway, I don't need to find out days if you look at the screenshot. I just need a formula to subtract the hours from Friday 10:30pm to Sunday 11:30pm.

 

[earthworm]

I don't think that's true as days are based on hours as well. Anyway, I don't need to find out days if you look at the screenshot. I just need a formula to subtract the hours from Friday 10:30pm to Sunday 11:30pm.

In my view you cant . How will excel know as to which 11:30 pm do you want to subtract without dates .

Do you want to subject time from 10:30 pm of Friday from 11:30 PM of Saturday , Sunday or Monday etc.

Hence without date you cant compute hours as there date is an x part.