Results 1 to 10 of 10

Sum in dd:hh:mm:ss

Threaded View

  1. #10
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,494

    Re: Sum in dd:hh:mm:ss

    If you change shg solution a bit you can also show duration over 31 days

    Formula: copy to clipboard
    =TEXT(DATEDIF(0,SUMPRODUCT(--LEFT(A1:A2, FIND(":", A1:A2) - 1)),"d"),"0:")&TEXT(SUMPRODUCT(--MID(A1:A2, FIND(":", A1:A2) + 1, 8)), "hh:mm:ss")

    ____
    little side step
    edit: assuming above text formula is put in A3 then follwing formula will allow you to convert this result into a value you can calculate with the outcome,
    (this formula van also be used on single dates in your area)

    Formula: copy to clipboard
    =SUMPRODUCT(--LEFT(B6, FIND(":", B6) - 1)) + SUMPRODUCT(--MID(B6, FIND(":", B6) + 1, 8))
    Last edited by Roel Jongman; 03-19-2019 at 06:16 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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