ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Combined date time cell to separate date & time components (https://www.excelbanter.com/excel-worksheet-functions/7325-combined-date-time-cell-separate-date-time-components.html)

Mark Ada

Combined date time cell to separate date & time components
 
From file dump have combined date time cells eg 14/04/03 14:20 (value
37725.59722). Want to perform time analysis so need to split to 2 separate
cells; eg. "14/04/2003" (value 37725) & "14:20" (value 0.59722). Is there a
fnc to do this? (Currently convert cell to value, then fncs trunc & cell
less int(cell) then refmt to date dd/mm/yy & time hh:mm respectively)


JE McGimpsey

Take a look at the answer you got yesterday to the same question.

If you didn't see the reply, after looking through the previous posts,
try searching the archives:

http://google.com/advanced_group_search?q=group:*excel*

using your name, email address, subject, or keywords in your post.


In article ,
"Mark Ada" wrote:

From file dump have combined date time cells eg 14/04/03 14:20 (value
37725.59722). Want to perform time analysis so need to split to 2 separate
cells; eg. "14/04/2003" (value 37725) & "14:20" (value 0.59722). Is there a
fnc to do this? (Currently convert cell to value, then fncs trunc & cell
less int(cell) then refmt to date dd/mm/yy & time hh:mm respectively)



All times are GMT +1. The time now is 09:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com