S
Soe
I like to enter date and time in a cell, can someone tell me the best way to
enter?
enter?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
liu shun
Enter "Ctrl+;"
D
Dave Hawley
Hi Soe
Lots of info on Dates and Times here
http://www.ozgrid.com/Excel/ExcelDateandTimes.htm
For the current date use;
Ctrl+;
For the curent time use;
Ctrl+Shift+:
For the current date and time, use;
Ctrl+; Space Ctrl+Shift+:
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
Lots of info on Dates and Times here
http://www.ozgrid.com/Excel/ExcelDateandTimes.htm
For the current date use;
Ctrl+;
For the curent time use;
Ctrl+Shift+:
For the current date and time, use;
Ctrl+; Space Ctrl+Shift+:
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
S
Soe
Hi,
Thanks for answers. However, there are some issues here.
1) i want to enter any date and time, not only current date and time.
2) user has to convert date to "General" then calculate (really calculate)
decimal for the time and added in, then change back to date format, which I
find is quite troublesome.
I am looking for simpler or easier way to enter both date and time.
anybody has any suggestion or experience?
rgds
Thanks for answers. However, there are some issues here.
1) i want to enter any date and time, not only current date and time.
2) user has to convert date to "General" then calculate (really calculate)
decimal for the time and added in, then change back to date format, which I
find is quite troublesome.
I am looking for simpler or easier way to enter both date and time.
anybody has any suggestion or experience?
rgds
F
Frank Kabel
Hi Sue
not really sure what your issue is. If the user enters a time like
'08:12' Excel will store/display this automatically as time. So why has
the user change this to 'General'?
not really sure what your issue is. If the user enters a time like
'08:12' Excel will store/display this automatically as time. So why has
the user change this to 'General'?
G
Gary Smith
Soe said:1) i want to enter any date and time, not only current date and time.
2) user has to convert date to "General" then calculate (really calculate)
decimal for the time and added in, then change back to date format, which I
find is quite troublesome.
I am looking for simpler or easier way to enter both date and time.
Just do it. I just typed the following into a cell:
12/31/2004 10:43 PM
Excel recognized it as a date and time, and reformatted the cell to
conform to my system settings.
S
Soe
oh! simple and great! it works.
thanks.
thanks.
Gary Smith said:Just do it. I just typed the following into a cell:
12/31/2004 10:43 PM
Excel recognized it as a date and time, and reformatted the cell to
conform to my system settings.