burnthepapper
New Member
- Joined
- Nov 9, 2020
- Messages
- 3
- Office Version
- 365
- 2019
- Platform
- Windows
Good day,
I am sorry if this question had already been asked, I've tried searching on the forum, and while there were people with similar issues, I was unable to find someone with the exact requirements.
I am trying to make a table that calculate how long a machine on a project site was out of commission between two timestamps while taking into account work hours. The issue is that the project site is conducted in three shifts, so the place is in operation from 5 AM to 1 AM (20 hours basically), 7 days a week.
I've tried to modify a few of the formulas offered for similar questions but to no avail, doubly so because I am unable to figure out a way to take into account the fact the "work day" spills over into next day.
Additionally, if it's not too much trouble, I'd really appreciate a few pointers on how to make the table universally applicable. As in, be able to define the start of the work day, end of the work day and which days in the week are work days and which are not or are holidays.
Thank you in advance for any assistance you may be able to help me.
I am sorry if this question had already been asked, I've tried searching on the forum, and while there were people with similar issues, I was unable to find someone with the exact requirements.
I am trying to make a table that calculate how long a machine on a project site was out of commission between two timestamps while taking into account work hours. The issue is that the project site is conducted in three shifts, so the place is in operation from 5 AM to 1 AM (20 hours basically), 7 days a week.
I've tried to modify a few of the formulas offered for similar questions but to no avail, doubly so because I am unable to figure out a way to take into account the fact the "work day" spills over into next day.
Additionally, if it's not too much trouble, I'd really appreciate a few pointers on how to make the table universally applicable. As in, be able to define the start of the work day, end of the work day and which days in the week are work days and which are not or are holidays.
Thank you in advance for any assistance you may be able to help me.