View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Six Sigma Blackbelt Six Sigma Blackbelt is offline
external usenet poster
 
Posts: 30
Default Displaying negative time in excel

I have a worksheet that displays appt. time & actual time in, some of my
actual time in data is greater than the appt. time ex: 13:15 appt time,
Actual time in 13:18, the cell should show :03 in red? but instead it gives
me a #VALUE!. How can I display this time, and show it as a negative time.