Hi
I have a range of cells which displays time in each cell ie from A1 to E1 as follows: -
A1 = 08:30
B1 = 10:00
C1 = 12:00
D1 = 14:15
E1 = 17:05
In cell A6 which is currently blank I would like it to display the ealiest time in the range and then in cell A7 the latest time in the range. Is this possible?
I would be grateful for any help on this.
Many thanks
Ηι
Try
=MIN(A1:E1)
=MAX(A1:E1)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Bingo - TVM
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks