Knowledge Drop

Table calculation for time difference accounting for negatives

  • 28 June 2021
  • 0 replies
  • 6 views

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!

Reply