Thread: Formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RM RM is offline
external usenet poster
 
Posts: 23
Default Formulas

How do I write a formula that if a number is greater than 40 hours (40:00:00)
it adds the number of hours(cells contents) to that 40 hours, and if it is
less than that 40 hours it will subtract a number (cell contents)? If anyone
can help I'd appreciate it as I am not that talented with Excel.