Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
LOOKUP and Time Calc
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calc time | Excel Discussion (Misc queries) | |||
Time Calc 24 hrs | Excel Worksheet Functions | |||
Time Calc | Excel Worksheet Functions | |||
calc time value | Excel Discussion (Misc queries) | |||
time sheet calc by time in and out | Excel Worksheet Functions |