I have a work schedule which gives me reference numbers which relates to the time I have to work.
e.g. REF NO 540 means I have to work 06.35 - 19.20.
If I type 540 in cell B5, I would like 06.35 - 19.20 to automatically appear in cell B6 below.
e.g. REF NO 541 means I have to work 05.35 - 14.30.
If I type 541 in cell C5, I would like 05.35 - 14.30 to automatically appear in cell C6 below.
Hopefully all should become apparent in the enclosed spreadsheet.