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