Convert date/time format cell to date only in Excel

preview_player
Показать описание
The video offers a short tutorial on how to convert date/time format cell to date only in Excel.
Рекомендации по теме
Комментарии
Автор

Worked like a charm, very simple. .... where (C2) is the original cell location with Date and Time.

pjd
Автор

Maybe you could paste the formula, so we don't have to make mistakes typing it.

BradleyStockAu
Автор

I Want to convert EST/EDT time to IST time the answer is come time with AM/PM (or) another type is date with time but i want answer like this in IST time 14/06/2020 8:32:47 AM or PM any one can help from this

vijayakumard