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
69%
20%
6%
3%
2%
Reviews
S
Shivkanya Tukaram Adhav
5
free sangtat aani paise ghete
I
Inderjit Singh
5
yes
S
Swatantra Yadav
5
Very effective content which they have, I really appreciate to Learn Vern Team, I really enjoyed this course with easily applied into with work, thank you, Learn Vern Team. and I suggest to all.
S
Swatantra Yadav
5
Very simple language is using in this course to helps easily we have learnt. Keep it up Learn Vern Team.
M
Md Alijohar
5
Hii
E
Ejaz Hussain
5
i am very happy to learn with learnvern b/c i learn a very expertfull teacher and also improve my skills .it is very amazing app i will recommended all my best friend you must be learn this.
S
Shaik hussain
5
👍👍
S
Sunny Kanaujiya
5
Great application for any free skill courses.
T
Tanmay Rai
5
LearnVern is a blessing for the learners. No expense and unlimited learning on any topic. Hatsoff to the founders.
Share a personalized message with your friends.