Re: $$Excel-Macros$$ Counting the number of times in a range

2013-08-30 Thread Diannaha Thompson
I will give it a try thanks. On Friday, August 30, 2013 1:03:33 PM UTC-5, De Premor wrote: > > Try this attached sample, and let us know if it solve your problem > > On 30-08-2013 1:15, Diannaha Thompson wrote: > > Ok so I have this list of times 7am, 8am, 7:30, 9, 9:20am and etc. for > exampl

Re: $$Excel-Macros$$ Counting the number of times in a range

2013-08-30 Thread Diannaha Thompson
I will give it a try. Thanks. On Friday, August 30, 2013 11:00:09 AM UTC-5, ashish wrote: > > check the attachment see if it helps > > > > > On Thu, Aug 29, 2013 at 11:45 PM, Diannaha Thompson > > > wrote: > >> Ok so I have this list of times 7am, 8am, 7:30, 9, 9:20am and etc. for >> example. I

Re: $$Excel-Macros$$ Counting the number of times in a range

2013-08-30 Thread De Premor
Try this attached sample, and let us know if it solve your problem On 30-08-2013 1:15, Diannaha Thompson wrote: Ok so I have this list of times 7am, 8am, 7:30, 9, 9:20am and etc. for example. I need to count how many times occur in a range. So 7:00-7:59 occurs twice 8am-8:59 occurs once. I have

Re: $$Excel-Macros$$ Counting the number of times in a range

2013-08-30 Thread ashish koul
check the attachment see if it helps On Thu, Aug 29, 2013 at 11:45 PM, Diannaha Thompson < littlesqueak2...@gmail.com> wrote: > Ok so I have this list of times 7am, 8am, 7:30, 9, 9:20am and etc. for > example. I need to count how many times occur in a range. So 7:00-7:59 > occurs twice 8am-8:5

Re: $$Excel-Macros$$ Counting the number of times in a range

2013-08-29 Thread Paul Schreiner
Are the "times" actual EXCEL TIME or a string?   If it's ACTUAL Excel time, then the values are actually numbers. That is, the fractional part of a day.   6:00am is .25 6:00pm is .75   So, to determine how many values are between 7:00am and 7:59am, you're actually wanting to count the number of val