Im trying to create a formula which shows me the Case age. I have following formula which does the right job except its NOT showing the seconds. I tried several ways to include the seconds but i always get error messages.
Can anybody help me and give me some hints on how to add the seconds here?
IF( ISPICKVAL( Status , "Open"), TEXT(FLOOR((NOW() - CreatedDate) *24)) &" Hours "& TEXT( ROUND(MOD((NOW()-CreatedDate)*1440,60),0) )&" Minutes ", "" )