Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
ShowAll Questionssorted byDate Posted
MSheridan

# Case Aging and Business Hours

Hi All! I have two formulas. The first one I created to keep a running ticker of the number of days, hours, & minutes a case has been open. It looks like this:

Text(FLOOR(NOW() - CreatedDate)) &" "&"day(s)"&" "&Text(FLOOR(MOD( (NOW() - CreatedDate) * 24 ,24))) &" "&"hrs"&" "&Text( FLOOR(MOD(((NOW() - CreatedDate) * 24)*60 ,60)))&" "&"min")
The second formula I got off the boards and it keeps track in business hrs the number of hrs a case has been open:

IF(AND(MOD(TODAY()-DATE(1900,1,7),7)< (NOW() - CreatedDate ), ((NOW() - CreatedDate )<7)),((NOW() - CreatedDate)-2) * 24, ((NOW() - CreatedDate)-(2 * ((NOW() - CreatedDate)/7))) * 24)

Both of these formulas work great, however, I would like to have the business hrs formula in the same format as the first formula. So it would be business hrs in days, hrs, and minutes. Does anyone have any ideas?? I keep playing with it but it is always off.
Mack
Hi,
FYI: The second formula is incorrect - if you have two date/times which are one hour apart, it calculates them to be 0.7 hours apart.

Mack
Hi,
FYI: The second formula is incorrect - if you have two date/times which are one hour apart, it calculates them to be 0.7 hours apart.
This was selected as the best answer
bdowney

Mack,

Is there any update the the correct formula for the business hours calculation? You indicated:

Mack wrote:
Hi,
FYI: The second formula is incorrect - if you have two date/times which are one hour apart, it calculates them to be 0.7 hours apart.

Thanks!

bdowney

Orion@gmail.com

The second formula from the Case Age package calculates by deduction not addition which is why the format is different. The formula counts backwards from 1 hour in the minutes rather than adding minutes to 1 hour.

mmrr