Time calc

[Peter1973]

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.

 

[Peter1973]

Am I doing something wrong keying this into the condition format box under if formula is ?

 

[Peter1973]

Think I have got it know but sorry to be a pain i have tried reversing the above for if i wanted to condition it if it was less that 61 mins not more than but just tried reversing the > into an < but it wont work for some reason.

 

[Andrew Poulsom]

This worked for me:

=(A2+(A2 < A1)-A1) < =TIME(0,61,0)