Time Calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Payment calculation 1
Calculate elapsed time excluding specific timeframe 10
Calculating time for 3rd shift 4
Count continuous duplicates 2
Return Corresponding Value Based on Comparing Two Sheets of Data 6
Screening through days of the week including time 1
Conditional Time Calculation 10
Show time as a negative figure 3

Back
Top