Thanks for the reply Colin. I have created a new spreadsheet with start (set) and end (haul) times and dates integrated. I have also got a separate sheet with sunrise and sunset dates and times integrated as requested. I tried my old VLOOKUP formula but it didn't seem to work now with these integrated? So I pasted in the old times anyway from the other spreadsheet.

Anyways any help again would be appreciated.

Cheers
Tim

Attached Files

Excel Example.xlsx (114.2 KB, 12 views)