Summing and saving time in a 24hr updating table.

Hi Everyone, I am making a spreadsheet and need help with summing time. I have daily values that change, monthly totals(which need to reset at the end of the month) and yearly totals. I need the monthly to update every 24hours, depending on the daily value, and save the value. As well as updating the yearly total. Again dependent on the daily value. Any help would be greatly appreaciated.

Daily Monthly Yearly
0:00 0:00 20:30
10:10 13:00 775:00
11:30 303:45 3530:35
0:00 187:15 2680:55
0:00 0:00 17:00
0:00 0:00 0:00
0:00 0:00 0:00
0:00 0:00 21:00
2:20 0:00 0:00
0:00 0:00 0:00
0:00 0:00 11:00
24:00 504:00 7056:00

2 thoughts on “Summing and saving time in a 24hr updating table.

  1. Excel Geek

    Hi there

    Do you want the monthly values saved in another spreadsheet every 24 hours? Or would you prefer it to save the value in place before the next update?


  2. mraus70

    I would like the monthly and yearly totals to update and save at 24:00 in place. That way in the next days report the monthly and yearly hours are correct from the previous day.I would also like the table to reset the monthly hours at the end of each month.
    Thanks for taking the time. Appreciated.

Leave a Reply

Your email address will not be published. Required fields are marked *