View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
badboy badboy is offline
external usenet poster
 
Posts: 45
Default Error in subtracting times

Good morning all,

Perhaps you can help with a question;

When subtracting times using the time format, and the answer is a negative
time, the answer shows like this ##########

Cell A1 20:00 - Cell A2 50:00 = Cell A3 #######

Is the any way to fix this?

Thank you in advance.