Calculating time between two times

Get Help
1

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.

Screen Shot 2022-03-04 at 9.31.17 am
Screen Shot 2022-03-04 at 9.31.17 am408×521 36 KB

I will be so grateful for any help on this!

Thanks

2

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.

3

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