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:21. End time: 5/3/2024, 9:24.
By considering working hour 8~5pm and holiday is on 5/1/2024.
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:21. End time: 5/3/2024, 9:24.By considering working hour 8~5pm and holiday is on 5/1/2024. Read More