Hi Shariq

No Problem.

Concerning your other problem: I'm not sure if i know what you mean.
You have a time, in let's say column A and in column B you want to have
your result. If Column A is less than an hour, B should be an hour.
If A is more than an hour, B should display the value in A!

Did I understand you right?

Cheers Carlo



"Shariq" wrote:

Thanx carlo!
you've been a great help to me, on this matter, but I've got another
question for you if you can help me with that too, I'd appriciate it very
much.
OK Its about calculating time, I've formatted cells into time, and then
another cell, which produces the result, however my worry is if time spent is
less then an hour, it should produce result as minimum of an hour, but if
time exceeds an hour it should just calculate what ever time is spent.
formula =D7-B7+(D7<B7), This is what I've typed and have already tried
different stuff, but that all have too many errors in it.
I hope I got my query right, and you understand what I want, any suggestion
would be appreciated,
Thanx,
Shariq