Hi Jennis,
Try setting Tools-Options-tab Calculation-option 1904 data system to ON.
To color negative red:
- Format-Cells-tab Number
- category Custom with code +hh:mm;[Red]-hh:mm
Give it a try, Frans
"jenniss" wrote in message
...
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?
|