Split combined date time data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Mark,

It seems that =INT(A2) and =MOD(A2, 1), suitably time or date formatted,
would be the ticket. But it seems that's what you're already doing, and
want something else.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

split combined Time Date cells 2
Combined date time cell to separate date & time components 1
excel 2000: split combined date time data (for both value and disp 1
Date Stamp with protection 6
Split a date/time column into 2 columns 1
Calculate the amount of time over a permitted amount (12 hours) 7
splitting date and time information in cells 5
Date and years calculation 2

Back
Top