I am trying to find a formula that will give me the middle time in between 2 times, I know it doesnt make sense.
Basially I enter in A1 21:00 and in A2 01:00 so i would be looking for the answer 23:00 as it is half way between the 2 times.
any help appreciated.
Basially I enter in A1 21:00 and in A2 01:00 so i would be looking for the answer 23:00 as it is half way between the 2 times.
any help appreciated.