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
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
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
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
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