Hi?
May I have some one help which formulas can count by Time as attached sample COL ?E? to measure with the commitment time at the COL ?C? and wanna count numbers of the stop less than 1 hours at COL I?
Your help I many thanks
Hi?
May I have some one help which formulas can count by Time as attached sample COL ?E? to measure with the commitment time at the COL ?C? and wanna count numbers of the stop less than 1 hours at COL I?
Your help I many thanks
Sorry to have missing attachment
That data is lamentably lacking for us to determine what to do, No times, what is No. of stop, what is Time Zone, etc., etc.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Dear XLD
sorry about the message not clear, the no of Stop is that's means " numbers of the stop deivered "
and the time shown at col E' that I chage to decimo.
Dear XLd
I has change back to time formats as attached
Your two replies have added nothing to what I already ken (didn 't know). You haven't explained anything more, so as yet I can't help.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Dear xkd
Actully that's I wanted to count how many company's to have delivered within one hours by COL E" to measuer with COL"C
Thanks ur help
=SUMPRODUCT(--(E2:E14-C2:C14<=TIME(1,0,0)))
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Exactly, thanks very much
kk1966, see what a clear explanation can get you as a response?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
hi
Aussiebear, I don't know what kind of you sent and which explanation as you want,
Please let me know if I made any wrongs, and which parts changes are need
KK,
thanks
Read through the posts you made in this thread. It wasn't until post #7 that you actually indicated what you really needed, then XLD was able to assist you.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link