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?

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?