I am trying to combine 2 cells into one, but have a few "if" issues.
I am attaching a workbook example to help.
I want to take the cell value of "B1" which is 6:00 and combine it with cell value of "C1" which is 4:00 and have that show in "B14" as 6 - 4.
In this scenerio I am taking the first numeric figure from each cell, separated with a " - " character.
I will then move on to D1 & E1 etc.
Is when the time is anything other than the whole hour. For example if "B1" = 6:30 then it would truncate the 0, leaving the 6:3 add the " - " then the first digit in cell "C1".
Range "B14" would show 6:3 - 4 (if this is impossible - then the whole 6:30 would have to be worked with, if it not a whole hour)
Is this possible? I have tried a few things - but this is out of my league.