View Single Post
  #1   Report Post  
jenniss
 
Posts: n/a
Default 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?