Time Calculation
 

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

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

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