Excel - formatting a cell number
I am using Excel to monitor an aircraft's modification status, maintenance and hours. I want to record aircraft hours in hh:mm and link it to other cells to show time run/remaining etc.
I have tried the options available in Excel but cannot get (for example) a current hours of 8000:00 against a Fatigue Life Limit of 12000:00 to get a cell to show the difference (4000 hours); all I get is "value"
Any ideas?