Comparing Times

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
 
B

Bill Ridgeway

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
 
T

trumpy81

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.
 
Top