Forum Discussion
Solved
Formula to calculate response time in hours and minutes
Hi Anyone can suggest the formula to calculate the total time use for a response. Example below: Example 1: Start time: 5/1/2024, 16:19. End time: 5/2/2024, 10:39. Example 2: start time 5/3/2024 9:...
Hi,
I have tried the formula, but it seems not excluded weekend.
Example below: Start date: 2/2/2024, 3pm, End date: 2/5/2024, 8am. 2/3 & 2/4 is weekend.
But the results show 83hrs.
Besides,
I will need 2sets of record total response time for Planning and ISR, but the formula does not work for the total response time in ISR. Need assist as well.
I have adjusted and corrected my function again. I think it should work now. But you would have to extend the list of public holidays for your country. Also, if you want to use this formula commercially, you would have to put it to the test with lots of examples.
- Hi, Thanks for the help! It works now.