Home |
Search |
Today's Posts |
#1
|
|||
|
|||
now() sumproduct.
I used to type enter time manually as under in coloumn B and D
Clients Check In Clients Check out 15 12:24 PM 23 2:34 PM Then i used this as a time stamp. =IF(C1178="","",IF(G1178="",NOW(),G1178)) etc etc to stamp time when i enter values in coloumn A and C. now there is a sumproduct function that uses cell say B2 to calculate number of clients checked in at that time.. sumproduct(B2:B500=E2)*(A2:A500) This used to work manually, until i used time stamp now..which gives out result as 23/09/2005 5:09:36 PM and not 5:09 PM. So sumproduct cant find 5:09 Pm in coloumn B. TIA. |
#2
|
|||
|
|||
Try
=sumproduct((MOD(B2:B500,1)=E2)*(A2:A500)) -- HTH Bob Phillips "Nimit Mehta" wrote in message ... I used to type enter time manually as under in coloumn B and D Clients Check In Clients Check out 15 12:24 PM 23 2:34 PM Then i used this as a time stamp. =IF(C1178="","",IF(G1178="",NOW(),G1178)) etc etc to stamp time when i enter values in coloumn A and C. now there is a sumproduct function that uses cell say B2 to calculate number of clients checked in at that time.. sumproduct(B2:B500=E2)*(A2:A500) This used to work manually, until i used time stamp now..which gives out result as 23/09/2005 5:09:36 PM and not 5:09 PM. So sumproduct cant find 5:09 Pm in coloumn B. TIA. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |