cell to = last time in column

[robert.begley1]

Hi guys and gals,
I am having difficulty in getting a cell to show the last time entry in a range, and to remain blank if no dates have been added yet.

example
column A

15:30
15:40
17:31
19:29

19:29 (this cell to show last time entered in range (but to stay blank if no dates have been entered) or show 17:31 if 19:29 has not been entered

I have found using time in a spreadsheet rather taxing on the ol grey matter, but this one is really doing my head in.

I will be very grateful if anyone can help me with this, a formula would be better for me than a macro,

thank you for taking the time to read this
cheers
Rob

[martindwilson]

you mention dates ,but assuming time with times starting in a1
=IF(COUNT(A1:A1000),LOOKUP(99^99,A1:A1000),"") cell formatted time

[robert.begley1]

Thank you so much,
yes I did mean time, I think the hours are starting to tell, must get some sleep soon, but now that you have sorted the missing piece of puzzle , I think I may be in for a long night.

works perfect, thank you again.

cheers
Rob

[robert.begley1]

one last question, does the 99^99, tell the machine that it is Time format that it is looking for

[martindwilson]

no its just a very big number ,time is stored as numbers, if lookup cant find a match it returns the last number it finds

[robert.begley1]

cool thank you
I am a little tired and cant find my notes, please can you remind me how to sum a range but leave cell blank if no data is entered

1
2
3
4

10 (blank if no numbers in range)

cheers
rob

[FDibbins]

=if(sum(range)=0,"",sum(range))
or
=SUMIF(range,"<>""")