Knowledge Drop

Table calculation for time difference accounting for negatives

Userlevel 3

Last tested: June 15, 2020


The general logic here is, if the time diff is negative, then build own results using diff_minutes/diff_seconds, otherwise; do the calculation.

if(${history.created_time}<${history.completed_time},concat("-",ceiling(diff_minutes(${history.created_time},${history.completed_time})/60), ":", abs(mod(diff_seconds(${history.created_time},${history.completed_time}),60))),to_string(${history.completed_time}))



This content is subject to limited support.                



0 replies

Be the first to reply!