In this tutorial let us see How to Remove Time from Date/Timestamp in Excel
When you extract dumps from some tools, you will be getting dates with the time format as well. But if you wish to have the date without any time, you need to watch this video now.
Let me take an example like this where I have dates along with time in column A
I will show you three ways of removing the time from the dates.
First one, copy the data from column A and paste in column B. Select cells in which you want to remove the time
Right-click and select “format cells”, in the Number tab, In the left pane, click on the Date option.
In the options on the right, select the format in which you want the date to be displayed, I am using the location as the US and selecting this date format.
By this method, you can hide the time from the timestamp and you can see only the date now.
Using the INT formula
Type formula in cell C6 as = INT(A6). This formula returns only the integer part and removes the decimal part. since the time value is 0, it shows 12:00 AM for all the cells.
Now, Right-click the cells in column C and format and change it to Date format to only show the date and not the time.
This is using the Datevalue formula
Type formula in cell D6 as = =DATEVALUE(TEXT(A6,”dd-mmm-yy”))
Now, You will see the result as a number – which is the numeric value for the date, change the format of the result to a date format.
So like this, you can remove or hide the timestamp from the date value.
So, friends, this is all about How to Remove Time from Date/Timestamp in Excel
I hope you have enjoyed this tutorial, If yes, please do give me a like, share and comment.
For further more interesting videos, please do subscribe dptutorials.
For Personalized detail learning, write to firstname.lastname@example.org
If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later.
★ My Online Tutorials ► https://www.dptutorials.com
LEARNING RESOURCES I Recommend: https://www.dptutorials.com/resources
Subscribe for more Awesome Tutorials: http://goo.gl/NyAtg2
Support the Channel via shopping: http://ift.tt/2jH38PR
Tools that I use for Vlogging:
• Laptop: https://amzn.to/2E5U3MO
• Canon 200D Camera: https://amzn.to/2HglDYA
• Benro Tripod: https://amzn.to/2ExRvYj
• Blue yeti microphone: https://amzn.to/2VwZyPn
• Collar Microphone: https://amzn.to/2VyOdcM
• Bluedio Headset: https://amzn.to/2W3xUZX
• Screen recorder: https://techsmith.pxf.io/2BMjA
• Boom Arm Stand: https://amzn.to/2VCQNi7
• Zoom H1 Audio Recorder: https://amzn.to/2VDumsT
• Harison Softbox Studio Lights: https://amzn.to/2LY7x3u
• Chroma Key Green Screen: https://amzn.to/2ExTr31
• Background Support Stand: https://amzn.to/2McqnEv
• Acoustic Foam Background: https://amzn.to/2EoQ1zj
• USB RGB LED Strip: https://amzn.to/2VItKm4
• Wireless Mouse: https://amzn.to/2E23cpN
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
You Can Connect with Me at:
excel formulas in English, excel in English, excel tutorial in English,ms excel in English,ms excel tutorial in English, learn excel in English,vlookup in excel in English, learn ms excel in English, excel training, excel tutorial, Microsoft Excel 2007, learn excel,tutorial excel, ms excel tutorial, excel tutorials,ms excel 2007,Microsoft Excel training,learn excel online,learning excel,free excel training,online excel training,advanced excel tutorial,excel tutorial, excel formulas and functions, excel formulas, excel tutorial in Hindi, excel formulas and functions in Hindi, excel tricks, excel in Hindi, excel shortcut keys, excel vlookup, excel formulas in Hindi, excel for beginners, excel for accounting, excel formulas and functions tutorial, Excel Sum Formula, Sum Formula series, excel attendance sheet, excel salary sheet, excel stock maintain, excel data entry, advanced excel tutorial,excel formulas,excel tutorial,vlookup excel,excel accounting,excel for beginners,excel shortcut keys,excel sum formula,excel training,excel training online,excel tricks,free excel training,learn excel,learn excel online,microsoft excel training,attendance sheet in excel,excel data entry,excel formulas and functions,microsoft excel 2007,