Problems entering -7:20 in cell
Posted by Gerald Marshall on November 16, 2001 1:24 PM
This is probably a very stupid question but I can not find a way round it.
In cell A1 I want to write -7:20 (As in time, with a colon separating the hours from the minutes). In Cell B1 I want to enter 5:20, I want to end up with -2:00 in cell C1. How do I do it?
My problem is that when I enter -7:20 in cell A1 it assumes I am entering a formula and will not let me enter it.
Any help greatly appreciated.