The quickest way to do this is to press Shift+Ctrl+; (that's a semicolon) in Excel's built-in shortcut for entering the current time. You'll see the current time as you want it if the cell is configured to show times in 24-hour format.
Choose the cell where the current date or time should be entered. To insert the current date, use the shortcut Ctrl + ; (Control + semicolon). To insert the current time, use Ctrl + Shift + ; (Control + Shift + semicolon). Use the combo (Ctrl + ;) as a shortcut.
The first thing that you need to do is to select the cell in which you want to enter a date. Now, you can use the keyboard shortcuts or click on the 'Date' button on the toolbar. This will open a drop-down menu with all possible date formats. You can then select any one of them and enter your date in it.
The easiest way to enter a time in MS Excel is to use the "TIME" function.
This function takes two arguments: Hours and Minutes.
For example, if you want to enter 10:00 AM, you would type "=TIME(10,0)" into your cell.
If you want to enter 10:30 AM, you would type "=TIME(10,30)".
The formula is as follows:
=DATEDIF(Start_date, End_date, "y")
Learner's Ratings
4.4
Overall Rating
68%
20%
6%
3%
3%
Reviews
M
MORI PARTH RAMESHBHAI
5
good
S
Shahroz Alam
5
IT'S VERY GOOD AND USEFULL APLICATION WHERE WE CAN LEARN MANY COURSE AND MAKE CARRIER FREE OF COST . HOW CAN I APPRICIATE YOU I DON'T HAVE ANY WORDS REALLY IT'S VERY USEFUL FOR WHO CAN DO JOB LIKE ME
K
Kuntal Das
5
In this video they have mentioned like 2.1% increase in the salary how it can be above 1 lakhs , it should be 52000+2.1%+52000 which seems to be 53092 so, it's my feels as per the question they have
C
CHIRAG MITTAL
4
this is very help for excel study .thanks
D
DEVRAJ SINGH
5
I M VERY IMPRESSED SIR, THIS KNOWLEDGE IS VERY UISEFULL SIR
THANK YOU SO MUCH SIR
R
RAJNI SWAMI
5
I'm very lucky because I have this app. I learned a lot from this app and will keep learning.
Thank you so much LearnVern.
A
Ahad Hussain
4
best app for learning
P
PAVAN SIRSAT
5
This is very useful app by all courses in this app and thanks for learnvern
Share a personalized message with your friends.