plus or minus difference

[Dale G]

I need collum E to show the difference of collum C & D in a plus or minus
format

A B C D E
1 Run Bus Time Actual Diff

2 908 24412 4:47 4:49 = + or -

 

[charlie]

You can use an IF formula. Assuming that you want a + if colum D is greater
than column C it would be:
=IF(D2>C2,"+","-")

 

[Dale G]

A B C D E
1 Run Bus Time Actual Diff

2 908 24412 4:47 4:49 = + or -

for example above column E2 should read 0:02. (which I know is =D2-C2) If
the entry in D2 is 4:46, how can I set the cell to show the negative amount,
along with the ability to show the positive amount.