| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find next time in a range
XL2003, Win xp
Is there a way to find the next time in a range, where the times are arranged randomly? So in range A1:H5 the code looks for the time after the nominated time. So:- If A = 10:30AM and the next time in the range is 11:15AM then B=11:15AM End if And then I would make A=11:15AM and look for the next time in the range. And so on until I have my list Any help would be greatly appreciated. Ta, Martin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Last cell in Range when range is date format | Excel Discussion (Misc queries) | |||
| find the difference between start time and end time when spanning. | Excel Discussion (Misc queries) | |||
| verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
| Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
| Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
