date/time question
 

Hi,
I have a range of dates, representing the times that a file arrives for
processing every day. Does anyone know how I can find the earliest time,
latest time, average time from this range.
Of course, when I select min(...) it gives me the earliest date, not
necessarily the earliest time from the range. I would like to test the data
based purely on the time element, disregarding the date component. I am
using Excel 2002. Thanks.


Regards,


mk

date/time question
 

Suppose your data is in columns A, then use the following formula:

=MIN(TIME(HOUR(A1:A4),MINUTE(A1:A4),SECOND(A1:A4)) )

confirm with control shift delete

Use the same for the others, MAX, Average


Mangesh


"mk" wrote in message
...
Hi,
I have a range of dates, representing the times that a file arrives for
processing every day. Does anyone know how I can find the earliest time,
latest time, average time from this range.
Of course, when I select min(...) it gives me the earliest date, not
necessarily the earliest time from the range. I would like to test the
data
based purely on the time element, disregarding the date component. I am
using Excel 2002. Thanks.


Regards,


mk

date/time question
 

mk,
Check the Excel help for:
TIMEVALUE
and read the link to "how Microsoft Excel stores dates and times".

NickHK

"mk" wrote in message
...
Hi,
I have a range of dates, representing the times that a file arrives for
processing every day. Does anyone know how I can find the earliest time,
latest time, average time from this range.
Of course, when I select min(...) it gives me the earliest date, not
necessarily the earliest time from the range. I would like to test the
data
based purely on the time element, disregarding the date component. I am
using Excel 2002. Thanks.


Regards,


mk

date/time question
 

Thanks Mangesh, that worked a treat.

"Mangesh Yadav" wrote:

Suppose your data is in columns A, then use the following formula:

=MIN(TIME(HOUR(A1:A4),MINUTE(A1:A4),SECOND(A1:A4)) )

confirm with control shift delete

Use the same for the others, MAX, Average


Mangesh


"mk" wrote in message
...
Hi,
I have a range of dates, representing the times that a file arrives for
processing every day. Does anyone know how I can find the earliest time,
latest time, average time from this range.
Of course, when I select min(...) it gives me the earliest date, not
necessarily the earliest time from the range. I would like to test the
data
based purely on the time element, disregarding the date component. I am
using Excel 2002. Thanks.


Regards,


mk

date/time question
 

Thanks.

Mangesh



"mk" wrote in message
...
Thanks Mangesh, that worked a treat.

"Mangesh Yadav" wrote:

Suppose your data is in columns A, then use the following formula:

=MIN(TIME(HOUR(A1:A4),MINUTE(A1:A4),SECOND(A1:A4)) )

confirm with control shift delete

Use the same for the others, MAX, Average


Mangesh


"mk" wrote in message
...
Hi,
I have a range of dates, representing the times that a file arrives
for
processing every day. Does anyone know how I can find the earliest
time,
latest time, average time from this range.
Of course, when I select min(...) it gives me the earliest date, not
necessarily the earliest time from the range. I would like to test
the
data
based purely on the time element, disregarding the date component. I
am
using Excel 2002. Thanks.


Regards,


mk

date/time question
 

To extract the time element you could use the =Mod(A1,1) function
therefore
=min(mod(DateTameRange,1)) 'array entered ctrl+shift+enter


HTH RES



I have a range of dates, representing the times that a file arrives for
processing every day. Does anyone know how I can find the earliest
time,
latest time, average time from this range.
Of course, when I select min(...) it gives me the earliest date, not
necessarily the earliest time from the range. I would like to test the
data
based purely on the time element, disregarding the date component. I am
using Excel 2002.