Hi, i have in sheet 1 a table with names, and in other 30 or 31 sheets i have
some of this names.
Ex sheet 1

A B
Name Total
John 00:2:14
Sarah 00:1:29

All other sheets

A B

John late 00:12:44
Mary late 00:00:15
Sarah late 00:04:18

Some names can be in 10 sheets or more, maybe less.
I need the formula in B2 sheet 1 and the formula to search....if A1=John,
than the sum of John B2 in all sheets were can John be found is=....
B2 cell have "late" in it....can the formula calculate only the late hours?
late 00:02:00 + late 00:03:00 = late 00:05:00 ???



Thanks in advance.