Google Sheets – How to Do Simple Time Calculation

google sheets

I have a really simple question, I have searched online and for the life of me, cannot work out how to do this:

  1. Calculate the total hours and minutes from a start time to a finish time?
  2. Calculate the grand total hours and minutes?

I’ve shared the document below, please feel free to copy & edit if you have the correct answer?

https://docs.google.com/spreadsheets/d/1K6NkBzcfdpWSkVThw48BXy52LWWwV4T6VEul2LuDqsU/edit?usp=sharing

Best Answer

Try: 

=mod(C2-B2,1)

and drag down as far as needed. Make sure the format the cells as duration. For the 'total time' a simple sum should suffice.

Related Topic