how can i create a formula or format the cells so the answer is a.
I am creating a timetable in excel!
i wish to create a formula that shows a negative result so 7:24 - 06:00
would be - 1:24 not ##########
also if this is possible to do can the figure be in the format showing -
figure in red when negative and inshowing + figure in black to show positive?
does anyone know the answer?
|