Thread: need help w/ formula for taking lunch & overtime out of a 9 hour
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jodee501 jodee501 is offline
external usenet poster
  
Posts: 1
Default need help w/ formula for taking lunch & overtime out of a 9 hour
I have a timesheet that calculates the time then takes out lunch & if over 8
hours put overtime in a column, but if the time is less than 8 it shows
negative ot instead of -0-. help !!!!
Reply With QuoteReply With Quote