I have a workbook that has a start time and end time on two rows in multiple. I am trying to collect all the data in a macro so I can manipulate it.
One row example
06:21
17:05
When I try and collect it it using VBA just gives me "06:21. But if I go to the worksheet and copy it into another cell (eg =B6) then it gives me 06:2117:05 which is what I want to collect using the macro!
Can anyone please help as it is driving me crazy!
Many thanks
Ian