Thread: Now()
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nick Hodge
 
Posts: n/a
Default Now()

or....

=TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Nick Hodge" wrote in message
...
Sorry...re-inventing the wheel..

=MINUTE(NOW())

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Nick Hodge" wrote in message
...
Steve

The theory of this works, but without running a ton of time tests I can't
try them all

=MOD(NOW()-1,1)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"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