Time Calculation

  • Thread starter Conditional Formatting
  • Start date
C

Conditional Formatting

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
 
M

Markos Mellos

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
 
Top