#1   Report Post  
Old November 22nd 05, 09:29 PM posted to microsoft.public.excel.worksheet.functions
Steve
 
Posts: n/a
Default Now()

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

  #2   Report Post  
Old November 22nd 05, 09:42 PM posted to microsoft.public.excel.worksheet.functions
Nick Hodge
 
Posts: n/a
Default Now()

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



  #3   Report Post  
Old November 22nd 05, 09:45 PM posted to microsoft.public.excel.worksheet.functions
Alok
 
Posts: n/a
Default Now()

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

  #6   Report Post  
Old November 22nd 05, 09:49 PM posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 06:14 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017