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


--
Regards
trumpy81

*** Please remove the `_ spam _' trap before replying to this message ***

One way:

=MIN(A:A)

Format as a time.

In article ,
"trumpy81" wrote:

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

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.


--
Regards
trumpy81

*** Please remove the `_ spam _' trap before replying to this message ***