Timetables - next departure how to find relative to system time
 

I have a train timetable with departure times in Excel. My app displays the
current system time when I open it. Whats the formula to search the departure
column for the next train within 20 minutes of the system time... Eventually
I'll put on Pocket Excel.

Thanks
--
Rob Wills
UK

Timetables - next departure how to find relative to system time
 

Match can be used to find the time. See help for details on inexact
matches. Match returns the offset into a range and you can combine that
with index or offset to return information in related cells.

to the best of my knowledge, Pocket Excel doesn't support VBA programming
(so you probably don't want to post in programming) or array formulas.

--
Regards,
Tom Ogilvy


"Wacky Races" wrote in message
...
I have a train timetable with departure times in Excel. My app displays
the
current system time when I open it. Whats the formula to search the
departure
column for the next train within 20 minutes of the system time...
Eventually
I'll put on Pocket Excel.

Thanks
--
Rob Wills
UK