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. |
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. |
All times are GMT +1. The time now is 03:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com