Running total of times in Google Sheets

Hi there,

I haven't used Excel for such a long time so have pretty much forgotten everything I used to know unfortunately.

I am trying to create a simple timesheet that I can add in hours and minutes for each month of the year and also some other misc items and then display the running total.

I can do this manually by highlighting the cells and clicking the SUM button, but not sure how I can have it so it adds up automatically and also work out in minutes/hours what the actual total time is.

Would anyone be able to help me set up the cell marked "TOTAL HERE" to automatically add up the values that are already there, and when I add a new row for the next month?

Any help would be great, thanks

Thank you very much for that.

Sorry, I had it in Google Sheets, but had to export it as I couldn't post a link to Google sheets.

Thanks for the attachment, that worked perfectly.

I assume this =SUBTOTAL(109,[Time]) is telling the cell to have a time format so the minutes will add up to 60 to them add an hour on?

I see, thanks. I guess I can use the values as hours, so 5.4 would just be 5.4 hours rather than 5.40 mins (that's even probably wrong!) but you get what I mean

Thanks for the reply.

I have placed that formula into D:1, but I am getting a value of 4.6 rather than your 110

Ah, I see, thanks. I didn't have the cells formatted correctly.

I am not sure if I am entering the times incorrectly, as for example I have added:

1.32 hours and 1.45 hours, but it is totalling to 2.46 hours

Attachment 761637

you said you wanted time in hours and minutes.

1.32 hours is 1 hour and 19 minutes.
1.45 hours is 1 hour and 27 minutes.
so the total is of course 2 hours and 46 minutes

if you just want to add numbers together, then forget all the advice previously given and just do a sum:

Please Login or Register  to view this content.