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 ",
""
)
Best Answer
Hopefully this will solve your issue:
It will display the value like this:
For more information about using formula, refer Formula Operators and Functions