Calculating time between two times

Hi All,

I can not figure out how to calculate the Hours and Minutes between two times.

What I need to do is calculate the hours and minutes between a Start Time and an End Time and ideally I need to store this as a variable.

When I tried the simple calculation End Time - Start Time it returned a decimal of 3/24 for 8 hours.

But I need to show the hours and minutes.

I will be so grateful for any help on this!


Hi @Archer ,

Simply multiply them with 1440 for minutes, INT() first to get only the fraction.

Do the same for hour but get fraction first from the above calculation.

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.