Find last time value in column

[Wim Geuens]

Hi,

I have a column with onyl time values in it.
Its updated through a macro that puts in the correct time value.

When calculating the total time that has passed, I have to change my formula every time.

Is there any possibility to have a formula that will give me the last time value in a column?

I tried the formula for the numeric and text values, but these didn't work

Thanks!
W

 

[json]

you want a formula that will return the last time logged?

i'm not sure how your spreadsheet is setup/laid out; a sample would be nice, but i would think the MAX function woudl do this....... depending on what your data looks like.

 

[Luke M]

To find the last numerical value within a range:
=LOOKUP(9E99,A1:A100)

 

[NARAYANK991]

Hi Wim ,

I assume that the macro is pasting fresh data into a particular column each time , after clearing the earlier data.

As long as the macro is not deleting cells , but just clearing the column of data , you can use a dynamic named range ; suppose your data is in column B , with the header label in B1 , and your times starting from B2 , go into the Name Manager , and define a named range Times as :

=Sheet2!$B$2:INDEX(Sheet2!$B:$B,COUNTA(Sheet2!$B:$B))

So when using your times range , and wanting to know the total time , which I assume is just a summation of all the individual times , you can use :

=SUM(Times)

Narayan