Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Now()
aaaaaahhhhhhh
going for more coffee =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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|