split combined Time Date cells

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

With your date/time in A1,
B1= Int(A1) Format as date
C1=A1-Int(A1) Format as time

Drag the formulae down as far as required.
 

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 date time data 1
Combined date time cell to separate date & time components 1
excel 2000: split combined date time data (for both value and disp 1
How do I delete merged cells in Excel without deleting the final d 5
Date Stamp with protection 6
splitting date and time information in cells 5
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y 2
Calculate the amount of time over a permitted amount (12 hours) 7

Back
Top