ExcelBanter - extracting time only

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - extracting time only (https://www.excelbanter.com/excel-worksheet-functions/183255-extracting-time-only.html)

Michel Khennafi

extracting time only

good morning

I have a seri of cells where the information inside is like

10/2/2007 4:38:00 PM

I would like to create 2 columns where in one of them I have the date only
and in the other I have the time only

Any idea as to what is the best thing to ddo?

Help is appreciated ... Thanks

Pete_UK

extracting time only

You can get the date with:

=INT(A1)

and the time with:

=MOD(A1,1)

if your date/time is in A1.

Format the cells appropriately.

Hope this helps.

Pete

On Apr 10, 4:34*pm, "Michel Khennafi" wrote:
good morning

I have a seri of cells where the information inside is like

10/2/2007 *4:38:00 PM

I would like to create 2 columns where in one of them I have the date only
and in the other I have the time only

Any idea as to what is the best thing to ddo?

Help is appreciated ... Thanks

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