plus or minus difference
 

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 -

plus or minus difference
 

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

"Dale G" wrote:

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 -

plus or minus difference
 

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.

"Dale G" wrote:

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 -