Elapsed Time Calculation?

Excel 2000 ...

Col F = Dates (format = mm/dd/yy)
Col H = Time Stamps (format = 1:30 pm)
Col K = Serial#'s

I need formula to calculate "elapsed time" between 1st &
last Date/Time stamps for each Serial#.

(Note: each Serial# has random # of time stamps)

Thanks ... Kha

Start by combining the dates and time stamps in a single column. This is
simply F+H (eg. =F3+H3); though I'd recommend formatting the result column as
Date or Time with the full date and time. (Format|Cells|Number).

Then build formulas to find the highest value date and lowest value date for
each Serial number. The DMIN and DMAX functions will probably help here if I
understand your data. The difference between DMAX and DMIN is the result
you're looking for. You may need to format the result as a Number (rather
than a date/time) and you may need to manipulate it somewhat to get the
result you want (eg. multiply by 24 to convert to hours, divide by 7 to
convert to weeks, use the ROUND or TRUNC functions to extract either the days
or day fraction and convert to time....etc.)

Good luck!

"Ken" wrote:

Excel 2000 ...

Col F = Dates (format = mm/dd/yy)
Col H = Time Stamps (format = 1:30 pm)
Col K = Serial#'s

I need formula to calculate "elapsed time" between 1st &
last Date/Time stamps for each Serial#.

(Note: each Serial# has random # of time stamps)

Thanks ... Kha