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?


  • You might find this useful: How can I add hours in Google Sheets to show days? – Vidar S. Ramdal Feb 9 '15 at 12:21
  • This could be of interest as well: webapps.stackexchange.com/a/59871/29140 – Jacob Jan Tuinstra Feb 9 '15 at 12:27
  • Thanks Vidar, I'll have a look at that link. Thanks also Jacob, but I already check that page and this did not work on my spreadsheet. – Darren Feb 9 '15 at 16:10
  • Thanks pnuts, I've tried your code in the link (still there) but unfortunately that does't work either. – Darren Feb 9 '15 at 20:59
  • @Darren try formatting the output cells as 'duration' when using pnuts' formula. Alternatively, also try: =mod(C3-B3,1) and drag down. For the grand total a simple sum should do. – JPV Feb 10 '15 at 8:03



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


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.