Functions like now are referred to as volatile. That means that they are
recalculated each time XL performs a calculation. If XL does not perform a
calculation then the value is not updated. There is no easy way to force XL
to recalc on a regularily scheduled basis, so there is no easy way to make
the now formula act like a clock.
--
HTH...

Jim Thomlinson


"Hamed parhizkar" wrote:

When I put in =NOW() it outputs the date and time; however, the time does not
stay current. Meaning if I do the formula at 10:30, it shows the date then
10:30, but then at 10:31 it stil shows 10:30.... how do you make the time
continuous?

Thanks