In one column, I have 03:12:00 in hh:mm:ss format... in the next column, I have 32:00:00 in [hh]:mm:ss format.... when I add them together instead of getting 35:12:00, I am getting 587:12:00.
Basically, I am trying to add formulas to substract out weekend hours (Friday after 5, Saturday, Sunday, and Monday until 8) for a time ticket.... in the example above, the ticket was submitted Saturday night with 3:12:00 to go in the day.... I want to add 32 hours to that time to get the total time to deduct off the response time of a ticket
The total time is in the [hh]:mm:ss format... so it reads 62:48:00 in this example... I want to then subtract 35:12:00 fromt it and come up with 27:36:00
Basically, I am trying to add formulas to substract out weekend hours (Friday after 5, Saturday, Sunday, and Monday until 8) for a time ticket.... in the example above, the ticket was submitted Saturday night with 3:12:00 to go in the day.... I want to add 32 hours to that time to get the total time to deduct off the response time of a ticket
The total time is in the [hh]:mm:ss format... so it reads 62:48:00 in this example... I want to then subtract 35:12:00 fromt it and come up with 27:36:00