Hello,
I am working on a weekly schedule for my work. I have been trying my best to figure this out, trying different formula examples I found online, etc. I have had no luck so far.
To better help explain what I am trying to accomplish, I will post a picture of it:
In the image, you'll see the various schedules.
I am wanting to calculate the number of hours in yellow based on the information in the boxes above them, without doing so manually.
I was able to calculate time differences between say, 6 am and 2 pm. But then it doesn't account for when a person is off or when there's an overnight, third shift. When I use the same formula there, the calculate ends up a negative number.
If I type 6 am to 2 pm. I want it to input 8 hours below it. If I do 6 am to 6 pm, it will input 12. If I type OFF, I want to input 0.
I hope that makes sense.
Is this sort of thing even possible? Thanks so much!
I am working on a weekly schedule for my work. I have been trying my best to figure this out, trying different formula examples I found online, etc. I have had no luck so far.
To better help explain what I am trying to accomplish, I will post a picture of it:
In the image, you'll see the various schedules.
I am wanting to calculate the number of hours in yellow based on the information in the boxes above them, without doing so manually.
I was able to calculate time differences between say, 6 am and 2 pm. But then it doesn't account for when a person is off or when there's an overnight, third shift. When I use the same formula there, the calculate ends up a negative number.
If I type 6 am to 2 pm. I want it to input 8 hours below it. If I do 6 am to 6 pm, it will input 12. If I type OFF, I want to input 0.
I hope that makes sense.
Is this sort of thing even possible? Thanks so much!
