ExcelBanter - Convert date and time

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Convert date and time (https://www.excelbanter.com/excel-discussion-misc-queries/120344-convert-date-time.html)

Vijay Kotian

Convert date and time

I want this value in diffierent colums e.g. 27/11/2006 9:55 AM, how to take
only date in one column and time in another column?

David Biddulph

Convert date and time

=INT(A1) for the date, and =MOD(A1,1) for the time. Format each cell
according to your wishes.
--
David Biddulph

"Vijay Kotian" wrote in message
...
I want this value in diffierent colums e.g. 27/11/2006 9:55 AM, how to take
only date in one column and time in another column?

All times are GMT +1. The time now is 08:23 AM.