Hello,

I have a spreadsheet that I am trying to calculate the hours between two different cells based on the conditions of other cells. For instance Q:Q = Press, T:T = Start Date/Time and U:U = Stop Date/Time. I want to know how many hours were spent on press type X based on the date. Something like Sum (Stop - Start) if stop is greater than or = A2 and Press = B2. (A2 and B2 are where the drop downs are for what is in Press and Stop fields)

Any help would be appreciated.

Thanks,
Jay