Given cell Q123 is formatted to display a time as 13:37 entering =Q123-2:30 in another cell results in Err:502. Why?
Hallo
= Q123 - TIME(2;30;0)
Karolus
It seems to me that the colon does not make sense there.
Given cell Q123 is formatted to display a time as 13:37 entering =Q123-2:30 in another cell results in Err:502. Why?
Hallo
= Q123 - TIME(2;30;0)
Karolus
It seems to me that the colon does not make sense there.