thanks your a star you solved my problem, your pure geniuos

"Frans van Zelm" wrote:

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?