Alternative for pivot: in the Data tab of the ribbon go to Outline and press on SubTotal.
But... I've noticed your column H is not formatted as time (might be the problem in the pivot as well). Hence some results are "0".
When I formatted the column as time and did a text to column it worked.
View attachment 48839
Hi ,Dear Narayan,
thank you very much for the reply.
can you please review this again if you have a time. totals are not accurate.
some individual's total production time is zero(0). but when i checked the details, there is some production time.
thank you very much for your time.
Lasantha.
Hi ,
The problem was as Guido has already mentioned ; doing a Text to Columns converted all the values to times.
Another option would have been to replace the static time values in column H with the formula , as shown in the attached file.
Narayan
just for fun, the option Power Query... No need for a formula. Just define correct data types - Duration - and use a group by with a simple sum column.
My pleasure... Which version of Excel are you using? Power Query is available as from v2010 for windows users. But depending on the version, different ways to get it on the ribbon. You can check out some posts on the topic on the blog or the MS site.