excel 2000: split combined date time data (for both value and disp

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

Guest

From a file dump date & time info combined in single cell eg. "14/04/03
14:20" (value 37725.59722). For time period analysis I require 2 separate
cells (including separate values) "14/04/2003" (value 37725) & "14:20" (value
0.59722) respectively. Is there a simple fnc to do this? (Currently; convert
to value then trunc (cell) & cell minus int(cell) then fmt to date and time
respectively)
 
You need to repost this message to the Excel newsgroup.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
Back
Top