000SAMPLE COMPILED Daily PJM Report.xlsx000SAMPLE COMPILED Daily PJM Report.xlsx

I need to total the cumulative hours in each daily worksheet and travel hours daily

I thought i had the formula for the total hours using '*' as wildcard but when i add sheets it doesnt add into the formula...i will add sheets as needed for the dates on a particular project

1st i need help with the TOTAL HOURS on each date considering the fact that i will be adding sheets when necessary

2nd (still considering that i'll be adding sheets when needed) i would like to total the travel time cumulatively (using travel as a keyword in B10 through B19 to total the time to the right of it in Q10 through Q19) ---'travel' may end up being anywhere in B10-B19 or more than once daily b/c I may have different techs with different times on the same day

hopefully i explained myself well enough/// and hopefully the attachment is there (new here)Thanks in advance!