Quickly Enter Current Date and Time in Excel
HTML-код
- Опубликовано: 11 сен 2024
- Here's my entire playlist of Excel tutorials: bit.ly/tech4excel Learn how to quickly enter the current date and time into an Excel spreadsheet. You'll learn a couple of very helpful keyboard shortcuts that can save you lots of time and hassle. ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa...
I always watched your video every Monday, Thank you very much, please more Excel.
One cell can receive both date AND time as date is an integer (number of days elapsed since January 1st 1900) and time the fraction of the day that it represents. 12:00 being 0.5 and 18:00 being 0.75 for instance. To enter the current date AND time in one cell do same as you showed but only type a space in between the shortcuts. The integer part is the date, the decimal part is the time of that day. Here, you now have a bona fide timestamp! Works the same under MacOS with Command key instead of Control key.
Nice. Very useful. I track date and time.
Videos like this are life savers! No BS just pure knowledge. Thanks for this.
SO true!
What a great function in times of COVID-19!!!! Thank you! I really enjoy watching your short videos. It helps a lot.
Short and sweet, thank you! One quick question, I use Excel to track phone calls and the date I make the call. If I make many calls on the same day, I can't just click on the lower right-hand corner of the previous cell (drag it down) and have that date copied into the cell below it; I get the date of the following day. How can I replicate the date?
Very helpful. Already subscribed. Many thanks
Thank you for you service.
Great trick, thanks!😁
Thanks a lot.
I am following you everything is looks great and thank you for your explaining but I didn't get the search bar program
Thanks! That helped a lot!
Great video
Good work brother
i learned sth today😇.
thanks prof
yes it's very informative. Thank you!
thank you so much sir . take love
the shortcut for time does not work... :(
Press ctrl ;
Thank you so much
Thanks!
very helpful tks
Hello! Good video! Do you know what is the shortcut for the NOW function? In other words, how can I add quickly the NOW function without it changes over time? Thank you! Have a good one. Silvina
Awesome sir thanks a lot💙
thanks
not sure why this short cut doesn't work for my excel ctrl+; , or ctrl+shirt+; thank you for you knowledge sharing...
it doesn't work for me either...
Time is usually not separate from the date and should be recorded as such.
Use CTRL+":", CTRL+";" then Enter.
It is odd to use the TIME short cut followed by the DATE short cut.
On time cards, people have trouble with elapsed times across midnight because only the TIME has been recorded.
Or easier still, you can use =NOW() and hit enter.
@@themcserdwar Now is now, not then.
Also, using =NOW() and then hitting enter, selecting the cell again, then hitting the F2 key, then hitting the F9 key, and finally hitting enter again, gives you the Date first followed by the time, which you mentioned in your original comment. You can further refine it by customizing (for instance showing the time as AM/PM) by going into the Custom Numbering format and adding this to the m/d/yyyy h:mm format, so you end up with m/d/yyyy h:mm AM/PM.
Excellent!
hello if i want to add particular date properly in table listed..how to do it properly?
Thank you.
Is there a way to include date, time and day in one cell?
Why would anyone want to do that?
Thanks sir
The best
If I want to add the day with the date ( today) what would be the formula, please guide me?
🤩thanks
TY
Thank u sir
So how can i set a sequence of dates for only mondays tuesdays and thursdays?
How auto date will be enter in date coulom if data enter other referred coulom
Thx
ctrl shift ;
for time
=today
for date
Ctrl + shift + ; not working in excel for me. It worked two days ago. Any help would be appreciated.
Press ctrl +: , don't use shift
Hi my name is Catrinia and I can't get my date to save after hitting the save button I get these symbols after I hit enter ####
How do you add 00/ for example 02/04/2021 instead of 2/4/2021
Even after cell formation I'm not able to change the date formatting
how to auto fill the month and year to current month and year, example i will type "8" then automatically it will put date aug 8, 2022 and not jan 8 1900?
Tnx
How to make tomorrow date in today?
Nice nice
On Google sheets, you double click and a calendar pops up. Why can't I do that?
Is there a way to add military time? Not am or pm?
24Hr = HH:mm
not working for me on excel 2021. edit: u need to use shift also.
I need to make a classroom roster with dates, student numbers & birthdate. The template xcel has is horrible.
calender
please upload your content on Rumble thx
Thank you for the tip. By the way, , 11/30/?? Is my birthdate.
Omg you talked too much
Short and sweet, thank you! One quick question, I use Excel to track phone calls and the date I make the call. If I make many calls on the same day, I can't just click on the lower right-hand corner of the previous cell (drag it down) and have that date copied into the cell below it; I get the date of the following day. How can I replicate the date?
Thank You.