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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
How To Compare Two Csv Files Mainly Two Columns Containing Time 0
How to change font & size of (all) citation numbers? 7
Sum values in a column depending on start time in another column 5
pieces picked per hour 0
Space at end of multi page list to accommodate new entries 1
Lookup Not working as expected 5
how to compare formula's values? 4

Top