Conditional difference between cells
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 |
Conditional difference between cells
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 Have a look at SUMIF()... -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus |
nội dung được up bởi
bánh trung thu như lan, chúng tôi chuyên cung cấp các loại bánh Banh trung thu brodard chiet khau cao. Để biết thêm thông tin chi tiết liên hệ 0975 400 143 |
All times are GMT +1. The time now is 11:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com