# 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

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

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

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

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

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

See attached with UDF.

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

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.

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

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1