Subtract hours between two timestamps

How To
1

Hi

I want to subtract the hours between two different timestamps but cant get it to work. From a HTTP I get a booking startdate ex 08:00:00 and a booking enddate ex 15:30:00.

I want the result to be the difference between these 2 timestaps ex 07:30

2

Hey Zlatan,

quick and dirty way:

{{formatDate(parseDate(1.hour2; “HH:mm:ss”) - parseDate(1.hour1; “HH:mm:ss”); “HH:mm:ss”; “GMT”)}}

Make plays smart with the time zones, hence the GMT tag.

1 Like
3

Formatted to avoid the forum smart quotes:

e.g.: (paste this into the field)
{{formatDate(parseDate(240.t2; "HH:mm:ss") - parseDate(240.t1; "HH:mm:ss"); "HH:mm:ss"; "UTC")}}