LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default how to split date and time in one cell into multiple cells

I need to perform this function using worksheet commands - I do not want to
use the"manuel entry" of a wizard - I need to "split" date and time (09/24/09
8:40) into two distinct cells...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y nigeo Excel Discussion (Misc queries) 3 April 1st 09 09:38 PM
Split DATE cell into three new cells? Xx Licher xX Excel Worksheet Functions 2 December 14th 07 10:16 PM
Split Date and Time Cell Beamers Excel Discussion (Misc queries) 2 May 19th 06 07:25 PM
Split the date & time in one cell to be 2 colums. Aom Excel Worksheet Functions 3 April 11th 06 02:27 PM
split combined Time Date cells Mark Ada Excel Discussion (Misc queries) 2 December 1st 04 03:06 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"