TimT
4 years agoQrew Trainee
Calculating duration in hours but only for workhours
Hello,
I'm trying to create a formula that will calculate the duration of how much time it took to change a status of a record but only taking into account business hours.
For example:
work hours 8 am - 4 pm (M - F)
I tried looking around to see if this has been solved before but could not find anything. Appreciate any help on this!
------------------------------
Tim D
------------------------------
I'm trying to create a formula that will calculate the duration of how much time it took to change a status of a record but only taking into account business hours.
For example:
work hours 8 am - 4 pm (M - F)
- If I create a record at 3 PM on a Monday and it was modified by someone at 9 AM the next day, this formula should say that it took 2 hours from the time the record was created and then modified.
- Should not include weekends, so if it was 3 PM on a Friday and was modified by someone at 9 AM on Monday, it still should say 2 hours
I tried looking around to see if this has been solved before but could not find anything. Appreciate any help on this!
------------------------------
Tim D
------------------------------