+ Reply to Thread
Results 1 to 9 of 9

How to calculate cumulative time over different days in Excel

  1. #1
    Registered User
    Join Date
    07-25-2014
    Location
    London
    MS-Off Ver
    2013
    Posts
    15

    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
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    12-02-2012
    Location
    Melbourne, VIC
    MS-Off Ver
    Excel 2016
    Posts
    750

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

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

  3. #3
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    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. #4
    Registered User
    Join Date
    07-25-2014
    Location
    London
    MS-Off Ver
    2013
    Posts
    15

    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. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

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

    See attached with UDF.
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  6. #6
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    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. #7
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    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.
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  8. #8
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    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. #9
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 08-07-2013, 06:05 PM
  2. [SOLVED] How to Calculate time outside core hours regardless of Days
    By mehulsagar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-09-2012, 06:31 AM
  3. Replies: 4
    Last Post: 09-06-2012, 07:05 PM
  4. How to calculate days of the week in a given time frame
    By fsoares22 in forum Excel General
    Replies: 2
    Last Post: 03-17-2011, 12:09 PM
  5. Calculate Time Duration Spanning Different Days
    By mmjcarr in forum Excel General
    Replies: 1
    Last Post: 11-23-2009, 11:53 AM

Bookmarks

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