Now()
=MOD(Now(),1)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Steve" wrote in message
...
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
|