Course Content

If you are facing any issue in playing video please use Firefox browser.

Course Content


How to perform data entry of date-time


Now we will see that how we can perform data entry of date and time in MS Excel.


Date and time are very important feature to complete any data entry.


Firstly we will use '/' to enter date, that is when we want to enter any date we can write it as '16/10/2016'. Or else also '16/10/16', it will get directly changed to '16/10/2016'.


We can also use '-' to enter date, like '16-10-2016'.


If by mistake we have added any wrong date then it will be left aligned in MS Excel.


To manipulate date we have many functions in FORMULAS tab inside Date & Time option.


Similarly if we want to enter time we will use ':' symbol. Like - '2.30' , and if we want to show our time in 24 hour format then also we can write it as '14.30'. It is also correct.


If we are working in any Excel sheet which requires previous year data, then we have to enter the date manually because MS Excel has restricted the date at particular time period.


Overall date and time can be entered in Microsoft Excel by using '/' and ':' symbols.


Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download The Apps

Code Scan or Download the app
Google Play Store
297K+ Downloads
4.5 Rating
10K+ Reviews
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere