Comparing Times

  • Thread starter Thread starter trumpy81
  • Start date Start date
T

trumpy81

GDay All,

I have a spreadsheet with a number of columns. In these columns, times will
be entered (probably 24 hour style). I need to compare these times and
present the lowest time in another cell. However, I'm stuck for a formula to
calculate this.

Anyone here have any ideas??

Your help is appreciated!

TIA
 
That you are using time instead of numbers doesn't make any difference (just
in case you thought it would). You can use the same formula as elsewhere

=min(a1:b99)

will return the earliest time in the range.

Regards.

Bill Ridgeway
Computer Solutions
 
GDay All,

Thanx guys ... I knew it would be simple .... now all I need to do is to
determine which cell is lowest and then display the contents of the cell
beside it.
 
Back
Top