Thread: Calculate time, but if less then hrs, end result must be 1 hrs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Shariq Shariq is offline
external usenet poster
  
Posts: 31
Default Calculate time, but if less then hrs, end result must be 1 hrs
Hi everybody!
I need to calculate time but if the difference is less then 1 hrs, end
result must produce minimum of 1 hrs, and if difference is greater then an
hrs or minutes, that should be displayed, how do I do this?
Reply With QuoteReply With Quote