AnsweredAssumed Answered

Need assistance with my Elaspsed date/time calculation

Question asked by xxx202xxx on Mar 2, 2017
Latest reply on Mar 2, 2017 by philmodjunk

Hi All,

 

I am currently calculating how long a service ticket has been open in days.

 

Let ( Stop = If ( IsEmpty ( Date_Closed ) ; Get ( CurrentDate ) ; Date_Closed ) ; Ceiling (stop - Date_Created ) )

 

I now would like to change that to hours.  So would by new calc be:

 

Let ( Stop = If ( IsEmpty ( Time_Closed ) ; Get ( CurrentTime ) ; Time_Closed ) ; Ceiling (stop - Time_Created ) ) or

 

 

Let ( Stop = If ( IsEmpty ( Time_Closed ) ; Get ( CurrentTimestamp ) ; Time_Closed ) ; Ceiling (stop - Time_Created ) )

 

Thanks

Outcomes