Do you think this can be made to work where the values being worked with are times not ordinary numbers?
So if A1 = 9am and A2 = 5pm then A3=8:00 (the difference between the two)
But I'd like A3 to show a maximum of 6 hours
I've tried =Min(A2-A1,6) - this doesn't throw up an error but it doesn't give me the right result either!
Originally Posted by Grahamfff
Perfect! Thanks very much!