Thread: Calculate time, but if less then hrs, end result must be 1 hrs
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Roger Govier Roger Govier is offline
external usenet poster
  
Posts: 2,886
Default Calculate time, but if less then hrs, end result must be 1 hrs
Hi

With start time in A1 and end time in B1
=MAX(TIME(1,0,0),B1-A1)

--
Regards

Roger Govier


"Shariq" wrote in message
...
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