Calculate total hours between 2 hours/times

Hi everyone,

I have 2 buttons that use “pick time” to store the times in variables in the format, for example: 11:00.

So, my goal is to calculate total hours using this 2 times and store in another variable.

1st: 8:00
2nd: 10:00

total hours: 2 hours

What is the best way to do this? I could be wrong, but I didn’t find a native formula for this.

Thanks in advance

Hi, check out the DATETIME_DIFFERENCE formula function:

DATETIME_DIFFERENCE(date1, date2, “hours”)

Ty guys for reply. But i dont have datetime format i used “pick time” so my data is like 11:00, 10:00 , 8:00 …