Extract Date or time From Date time Field in Excel || Learn 4 Different formulas and VBA Code

#ExcelTips #ExcelFormula #ExcelVBA
Hello Friends,
In this video you will learn 4 different formulas to extract the Date or Time form a Date & time column in Excel.
You will also learn how we can do it using Macro and how to create shortcut key.

Download the practice file from below given link:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Twitter:

Pinterest:

Send me your queries on telegram:
@PKanExcelExpert

************* Suggested Books *********

************* My Stuff ****************

[bakareolayinka]

Thanks for this, you really helped me out

[rickkeev]

I also use the LCM function for date and substitute or subtract LCM from...for time

[jurihazarika]

Sir,
I liked to show your videos..it's very easy method to solve the problem.sir,
If 2dates are given, how can we separate from one column..
Example: 06.08.20 to 06.08.21
How to separate the number in one column.

[infosatish]

Yet another awesome excel tip... great video PK!!

[Goodsolbadguy]

Thank you very much. This helped me. I was really struggling with excel not recognizing time

[AASHUTOSH_K_SATH]

Priyendra bhaiya
Please help
How to automatic print in pivot table data filter change and print.

[sivasankarkandaswamy]

Sir unable to use this formula. Getting #value! Error. Pls help.

[KTsPridiction]

Thanks for this video and i want to know formula for below concept

I want to calculate working hours between two date and times - if case is allign to me on 2-Mar'19 02:00:05 and I closed the case on 5-Mar'19 17:25:05 and i worked only between 9 am to 9 In this case i want to know time duration in hours but non working hours(9PM to 9AM) should be exclude

[rakeshbond]

Dear How can we do it for Date, day and time

[matthewrogers]

Is it possible to extract the time and date from a data written as follows? Jun 01 2020, 03:32 PM

[khairulbashar]

Sir how to convert date from digit to words for example (6/4/1964 conv:to Sixth April Nineteen sixty four)

[radhikaanbu]

04/13/2020 07:54:25 i have this format and shows error for all 3-set of formulas

[AllUpdate-bj]

Ticket create date : 05/01/2024 09:30 AM, Ticket closing date: 07/01/2024 12:30 PM, I want the total duration but after 09 pm to 09 am i dont want to count the hours, whats the excel formula. please help.

[rohitrazz]

How to extract date if students is absent on particular date

[davidjames]

When I do the above, I only get 00:00, what's wrong??