Table calculation for time difference accounting for negatives

Knowledge Drop

Last tested: Jun 1, 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.                

Version history
Last update:
‎06-28-2021 02:58 PM
Updated by: