LOOKUP and Time Calc
Thanks Pete, but that's what I tried first, then I was reading on the forum
about forcing general to numbers which is why I tried the posted formula.
I appreciate your effort!
Thanks,
Greg
"Pete_UK" wrote:
Try it like this:
=LOOKUP(99^99,'[HBS wed.USER.xls]Sheet1'!$F:$F)*86400
I assume that the other file is open, otherwise you will need to
include the full path to the file. I also assume that the data you are
retrieving is recognisable as a time value.
Hope this helps.
Pete
On Jul 24, 3:24 pm, Greg wrote:
I am trying to find the last value in a column, then convert that value
(stored as "General") to seconds in the new sheet.
I've been trying:
=--(TEXT((LOOKUP(99^99,'[HBS wed.
USER.xls]Sheet1'!$F:$F)),"00\:00\:00")*86400)
but get a #N/A error.
Any help?
TIA
Greg
|