Steve
Just because you format the cell containing the Now() function to HH:MM
format or for that matter any other format does not mean that you cannot use
that value in other calculations. What format does is just change the
display. The intrinsic value of the cell remains unchanged.
Alok


"Steve" wrote:

I would like to use the the now function so that it only shows the time. I
know how to format it to (HH:MM). The problem with that is I am running
other formulas off of the now() function. any thoughts or suggestions are
always appreciated.

Thanks,
Steve