Tags: actula, calculation, column, columna, columnb, columnc, compute, create, excel, expected, formula, microsoft, msdn, software, tardiness, time

Time Calculation

On Microsoft » Microsoft Excel

1,209 words with 2 Comments; publish: Wed, 04 Jun 2008 18:57:00 GMT; (30662.50, « »)

columnA columnB columnC

Actula Expected Tardiness

hours Hours

6:20:00 5:00:00 =need formula on this column that will compute

Please help me create formula I already did =B3-A3 but the result shows ####

Any help would be appreciated.

Thansk

All Comments

Leave a comment...

  • 2 Comments
    • Swap your formula:

      =A3-B3

      Gary's Student

      "Conditional Formatting" wrote:

      > columnA columnB columnC

      > Actula Expected Tardiness

      > hours Hours

      > 6:20:00 5:00:00 =need formula on this column that will compute

      > Please help me create formula I already did =B3-A3 but the result shows ####

      > Any help would be appreciated.

      > Thansk

      >

      #1; Wed, 04 Jun 2008 18:59:00 GMT
    • use ABS(B3-A3) to avoid ####.

      However, if you need to work (i.e. sum, average, etc.) with the results,

      this solution will not work correctly.

      Reply if you need further help

      "Conditional Formatting" wrote:

      > columnA columnB columnC

      > Actula Expected Tardiness

      > hours Hours

      > 6:20:00 5:00:00 =need formula on this column that will compute

      > Please help me create formula I already did =B3-A3 but the result shows ####

      > Any help would be appreciated.

      > Thansk

      >

      #2; Wed, 04 Jun 2008 19:00:00 GMT