One last thing, its all good for most of it now but
how would I find the first and last for the five minute
intervals, also the total volume.

Since it's a multiple time interval the first and last would be:

First would use the same formula as if you were finding the first for 10:00.

Last would use the same formula as if you were finding the last for 10:05.

For the 5 min volume:

D2 = 10:00 AM
E2 = 10:05 AM

=SUMPRODUCT(--(HOUR(Times)=HOUR(D2)),--(MINUTE(Times)<=MINUTE(D2)),Volume))

Those seconds are really making this more complicated than need be. I don't
know why you had trouble trying to convert to just h:mm.

--
Biff
Microsoft Excel MVP


"swalk88" wrote in message
...
Hi,

One last thing, its all good for most of it now but how would I find the
first and last for the five minute intervals, also the total volume.

I've worked all the rest out and I have tried inserting the if function
into
the brackets but that didn't work.

Thanks

"T. Valko" wrote:

Ooops!

=MAX(IF((Times=D2)*(Times<=E2),Values))

That should be:

=MAX(IF((Times=D2)*(Times<E2),Values))

--
Biff
Microsoft Excel MVP


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
There is also a volume for a certain time, would I
just use a Sumif formula to find the volume at the time?

No, you'd need something like this:

For the total volume at 10:00 AM...

=SUMPRODUCT(--(HOUR(Times)=HOUR(D2)),--(MINUTE(Times)=MINUTE(D2)),Volume))

if I want to group the numbers in 5 minute intevals.
i.e. 10:00-10:05 how would I go about that?

Do you mean find the max from 10:00 to 10:05 ? Since the time values
included minutes and seconds you probably need to adjust the interval
to
10:00 AM to 10:06 AM. The reason is that there might be a time of
something like 10:05:59

Like this (array entered):

D2 = 10:00 AM
E2 = 10:06 AM

=MAX(IF((Times=D2)*(Times<=E2),Values))

How do I plot it on a chart and get it to
ignore that 0's that may appear in the data.

I rarely use charts but I think you need to replace 0 values with an
NA().

--
Biff
Microsoft Excel MVP


"swalk88" wrote in message
...
Hi again,

Thanks for that, that part is working now, just have a few more
questions.
There is also a volume for a certain time, would I just use a Sumif
formula
to find the volume at the time?

Also, if I want to group the numbers in 5 minute intevals. i.e.
10:00-10:05
how would I go about that?

Lastly, How do I plot it on a chart and get it to ignore that 0's that
may
appear in the data.

Thank you so much for the help.