| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get a current time using =TODAY() instead of 12:00 AM
In Excel, If I format a cell with date and time and enter =today( )
I get the correct current date and a time of 12:00 AM Never the current time. How do I get the current time? If I enter =NOW( ) I get the correct current time. Thanks. Keith |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I get a current time using =TODAY() instead of 12:00 AM
Hi Keith
use =Now() and format as mm/dd/aaaa hh:mm HTH Regards from Brazil Marcelo "Keith" escreveu: In Excel, If I format a cell with date and time and enter =today( ) I get the correct current date and a time of 12:00 AM Never the current time. How do I get the current time? If I enter =NOW( ) I get the correct current time. Thanks. Keith |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I get a current time using =TODAY() instead of 12:00 AM
Sorry, I should have stated that I wish the time and date to remain static,
never changing. "Marcelo" wrote: Hi Keith use =Now() and format as mm/dd/aaaa hh:mm HTH Regards from Brazil Marcelo "Keith" escreveu: In Excel, If I format a cell with date and time and enter =today( ) I get the correct current date and a time of 12:00 AM Never the current time. How do I get the current time? If I enter =NOW( ) I get the correct current time. Thanks. Keith |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I get a current time using =TODAY() instead of 12:00 AM
use =NOW()??!!!
"Keith" wrote: In Excel, If I format a cell with date and time and enter =today( ) I get the correct current date and a time of 12:00 AM Never the current time. How do I get the current time? If I enter =NOW( ) I get the correct current time. Thanks. Keith |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I get a current time using =TODAY() instead of 12:00 AM
I want the date and time to be static. =NOW( ) changes everytime I open the
worksheet. "Toppers" wrote: use =NOW()??!!! "Keith" wrote: In Excel, If I format a cell with date and time and enter =today( ) I get the correct current date and a time of 12:00 AM Never the current time. How do I get the current time? If I enter =NOW( ) I get the correct current time. Thanks. Keith |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I get a current time using =TODAY() instead of 12:00 AM
Keith,
If you want a static date/time you will need to use VBA to assign NOW() to your required cell(s). What event determines if/when the date/time changes (as opposed to everytime the w/book is opened)? "Keith" wrote: I want the date and time to be static. =NOW( ) changes everytime I open the worksheet. "Toppers" wrote: use =NOW()??!!! "Keith" wrote: In Excel, If I format a cell with date and time and enter =today( ) I get the correct current date and a time of 12:00 AM Never the current time. How do I get the current time? If I enter =NOW( ) I get the correct current time. Thanks. Keith |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I get a current time using =TODAY() instead of 12:00 AM
Keith
To enter a static date use CTRL + ;(semi-colon) To enter static Now time use CTRL + SHIFT + ;(semi-colon) To get both in same cell with space between CTRL + ; Let go of CTRL and hit <space then CTRL + SHIFT + ; Format to dd-mm-yyyy hh:mm Gord Dibben MS Excel MVP On Mon, 26 Jun 2006 10:30:03 -0700, Keith wrote: I want the date and time to be static. =NOW( ) changes everytime I open the worksheet. "Toppers" wrote: use =NOW()??!!! "Keith" wrote: In Excel, If I format a cell with date and time and enter =today( ) I get the correct current date and a time of 12:00 AM Never the current time. How do I get the current time? If I enter =NOW( ) I get the correct current time. Thanks. Keith |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I get a current time using =TODAY() instead of 12:00 AM
You can't. Today returns the date, not the time. -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=555679 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I get a current time using =TODAY() instead of 12:00 AM
OK. Thanks.
"Bearacade" wrote: You can't. Today returns the date, not the time. -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=555679 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I get a current time using =TODAY() instead of 12:00 AM
Hi Keith, what about to use =now() copy and past special values?
HTH regards from Brazil Marcelo "Keith" escreveu: OK. Thanks. "Bearacade" wrote: You can't. Today returns the date, not the time. -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=555679 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I get a current time using =TODAY() instead of 12:00 AM
Got it worked out using a user defined function in visual basic.
Thanks for the assistance. Keith "Keith" wrote: In Excel, If I format a cell with date and time and enter =today( ) I get the correct current date and a time of 12:00 AM Never the current time. How do I get the current time? If I enter =NOW( ) I get the correct current time. Thanks. Keith |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check box, then add current time to cell | Excel Worksheet Functions | |||
| current Date and time in cell | Excel Discussion (Misc queries) | |||
| Using "IF" and "AND" statements with current time | Excel Worksheet Functions | |||
| how do i insert the current time into a cell, and show different . | Excel Discussion (Misc queries) | |||
| how do you subtract military time? example 12:00 - 07:00 = 5 hour. | Excel Worksheet Functions | |||
Hybrid Mode
