# How to calculate cumulative time over different days in Excel

1. ## How to calculate cumulative time over different days in Excel

Hi Everyone

I need help to calculate the running total of time spent in the attached spreadsheet. Any help?

Thanks  Register To Reply

2. ## Re: How to calculate cumulative time over different days in Excel

See attached - Book5.xlsx
Hope this is what you wanted.  Register To Reply

3. ## Re: How to calculate cumulative time over different days in Excel

Hi LWLS,

Try the file associated with post #4 in the following thread:
http://www.excelforum.com/excel-gene...ml#post3747416

If it does what you want, and you can't implement it in your file yourself, I'll try to implement it in your workbook. If you want it implemented, please specify exactly where (which cell) you want the cumulative time. Your sample workbook is not clear as to what you want.

Lewis  Register To Reply

4. ## Re: How to calculate cumulative time over different days in Excel

Hi LJMetzger

I'll try your solution and feedback to you soon.

Thanks  Register To Reply

5. ## Re: How to calculate cumulative time over different days in Excel

See attached with UDF.  Register To Reply

6. ## Re: How to calculate cumulative time over different days in Excel

Alan,

Nice job, but the data doesn't seem to cooperate. Column 'A' contains date + time, so all the answers are twice what they should be. I think you have to change the formulas in the spreadsheet to be like: ``Please Login or Register  to view this content.``
Lewis  Register To Reply

7. ## Re: How to calculate cumulative time over different days in Excel

If you are looking for the time spent per day then I think that this could be the solution. I used a helper column (for ease of calculation) and added a column that had only the dates then calculated the time spent for each of those dates.  Register To Reply

8. ## Re: How to calculate cumulative time over different days in Excel

Thanks Lewis. I hadn't noticed that column A had a Time and Date.

Alan  Register To Reply

9. ## Re: How to calculate cumulative time over different days in Excel

Thanks Lewis. I hadn't noticed that column A had a Time and Date.

Alan  Register To Reply