Calculate the difference between the start and end times

Support
#1

Hello Yaw,

I designed a survey that it has start time and end time questions. What is the formula I need to calculate the difference between the start and end in minutes please!

Thanks, Hanan

How to calculate Minutes between two distint time in XLSForm
#2

Assuming the start and end occur on the same day, you could use something like:

int((decimal-time(${endtime}) - decimal-time(${starttime})) * 1440)

See decimal-time() for details. (BTW 1440 is # minutes in day)

1 Like