dates and times

A

aavm

I hope someone can help me with this problem, and new to the forum. I
my sheet col A is a list of dates and col B is a list of referenc
numbers col c is a start time and col d is an end time. Each date ca
have a number of reference numbers associated with it. Is it possibl
for excel to find the earliest start and latest finish time? if this i
possible is it also possible to specify times
 
R

Richard Neville

Go to Insert-Functions; for category select Statistical. The MAX function
will return the latest time, and the MIN function the earliest. Select all
the times in col C and apply the functions.
 
Top