ExcelBanter - ? E 1 = plus or minus the difference of D1 & C1

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - ? E 1 = plus or minus the difference of D1 & C1 (https://www.excelbanter.com/excel-discussion-misc-queries/195343-e-1-%3D-plus-minus-difference-d1-c1.html)

Dale G[_2_]

? E 1 = plus or minus the difference of D1 & C1

A B C D E

Run # Bus # Time Actual Diff

958 0 14:00
850 0 14:08
312 0 14:20
936 0 14:20
970 0 14:33
722 0 14:38

After I make a entry in collum D (actual) I need the difference to enter
automatically in collum E

Dave Peterson

? E 1 = plus or minus the difference of D1 & C1

You could put a formula in E2:
=if(count(c2:d2)<2,"",d2-c2)

Dale G wrote:

A B C D E

Run # Bus # Time Actual Diff

958 0 14:00
850 0 14:08
312 0 14:20
936 0 14:20
970 0 14:33
722 0 14:38

After I make a entry in collum D (actual) I need the difference to enter
automatically in collum E

--

Dave Peterson

All times are GMT +1. The time now is 08:51 PM.