Macro to find the Earliest Start Time and Latest Finish Time during a period

Dear All,
I am using Excel 2013 and have a problem as shown in the attached sample

I have data with Item No - Start Data - Start Time - Finished Date - Finished Time

Please see the sample Sheet1 where I have shown my desired Output required in Col H to L
In Col M I need to find the difference between finish time and start time

If start time and finish time are recorded as 0:00:00 then it should not be considered in the output
Also if there are erroneous entry eg Row 20 in the Sample data it should not be considered too in the output

The macro can give the desired output on a new sheet. For explanation purpose I showed the output on the same sheet


Hope to get some help
Thanks in advance
Rehana

How do you know row 20 is in error? What rule is applied? If the year is not the same as the rest of the data for that item? What about a start time on December 31st of one year and January 1st of the next year? How do you want to handle if there are three different years for the group?

We, as humans, can look at the data and say, "No, that doesn't look right." Computers need to be told specifically what isn't right.

Here is one solution that ignores this question. I simply "zeroed out" the bad data.

This solution makes use of an excel table (because they know how big they are and copy down formulas automatically) a couple of "helper columns" to combine the date + time and eliminate zero time values, and a pivot table to get the minimum start time and maximum end time.