Calculating time between two times

[Archer]

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!

Thanks

[Yongki]

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.