Calculate Difference in Time

[QFanatic]

Hi guys

Please find attached.

I need to calculate the difference in Time in script. Field name is  'Event_Duration'. I've tried doing it with interval but it returns nothing.

Where am I going wrong?

Thank you!

[haskia · Accepted solution]

Hi 

Make sure to convert your date and time fields from strings into actual dates or times with Date#(), Time#() or Timestamp#().

Then you can easily use calculations like Interval() and they will work like a charm.. 🙂 

Example for Duration:

=Interval(Timestamp#(Event_End_Dt_Tm, 'YYYYMMDD hh:mm:ss') - Timestamp#(Event_Strt_Dt_Tm, 'YYYYMMDD hh:mm:ss'), 'hh:mm:ss')

[QFanatic]

Thank you so much