Does anybody have the formula for the following:

If I have three fields (1.) start time (2.) end time. (3) Hours

If my hours equal less than 4 hours, how can I make my end time calculate itself, so that the Hours always equal at least 4 hour blocks?

I can generate the hours with the following calculation: Hour(end time

It would be helpful if you would update your profile to give what version you are using.

In FM7, the calculation:

I was just about to post but you beat me to it

Or: max(4, (end time -start time) )