Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 410
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,182
Default 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

  #3   Report Post  
Junior Member
 
Posts: 2
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Difference Between Dates WITH Conditional Formatting DOUG Excel Worksheet Functions 2 May 18th 10 10:25 PM
Using a conditional function to sum the difference between two col Detroit David[_2_] Excel Discussion (Misc queries) 3 April 26th 08 06:35 PM
Conditional Formating - Time difference Roman[_2_] Excel Discussion (Misc queries) 2 February 15th 07 10:23 AM
Conditional Difference between two dates [email protected] Excel Discussion (Misc queries) 2 July 10th 06 11:27 PM
Conditional Formatting - Difference between dates Gohan51D Excel Discussion (Misc queries) 5 March 14th 06 11:08 AM


All times are GMT +1. The time now is 07:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"