I need to calculate the time difference

I am a new user and having issues adding formulas to my table. I want to calculate the difference in time between start and end time and to show the results in hours and minutes. I was also hoping to account for a break between 12:00pm and 12:30 pm

Hi Taylor,

Thanks for reaching out to Jotform Support. I'll need some time to look into this. I'll get back to you as soon as I can.

We appreciate your patience and understanding.

Hi Taylor,

I'm still working out a solution to this. I'll get back to you as soon as I have one.

Thanks for your patience and understanding, we appreciate it.

Hi Taylor,

Can you try the formula below:

=TIMESTR(DATEADD(DATEADD({44},-MINUTE({43})-30,"minutes"),-HOUR({43}),"hours"))

And with Left added to only show it as HH:MM

=LEFT(TIMESTR(DATEADD(DATEADD({44},-MINUTE({43})-30,"minutes"),-HOUR({43}),"hours")),5)

Give it a try and let us know how it goes.