Calculate total hours between 2 hours/times

#1

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.

example:
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

#2

Hi, check out the DATETIME_DIFFERENCE formula function:

#3

DATETIME_DIFFERENCE(date1, date2, “hours”)

#4

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 …

image
image1316×258 16.3 KB

ty