• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

summation of time

giri ravirrala

New Member
hi,

i want do the summation of time as per column " machine " .

i am getting the total as formula "=C3+C4+C5+C6" in cell D6
but i am not able to get the total =Sum(c3:c6)

might have issues with cell formatting , but all are in time foramt only

kindly give the solution , sheet is attached

thanks in advance
 

Attachments

  • time summation.xlsx
    14.3 KB · Views: 4
The basic problem was with your data; at first sight it appeared that your formula should work. Unfortunately, what appeared to be formatted times (i.e. numbers between 0 and 1) were actually just character strings.

The SUMPRODUCT array formulas you have been given coerce the strings to give times, as do your formulas with the'+' operator. There are other ways of sorting the problem involving SUM, IF, and TIMEVALUE but what you have should do fine.
 
Back
Top