Forum Discussion

TimT's avatar
Qrew Trainee
3 years ago

Calculating duration in hours but only for workhours


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
No RepliesBe the first to reply