LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Extracting the Time from a Date/Time Stamp

In Excel I am trying to separate a date/time stamp into its component parts
(i.e., date, day of week and time), and place the components into separate
cells so that I can filter, sort and even graph based on this information. I
have figured out how to do the day of the week but I can't figure out how to
extract the time portion of the date/time stamp. Does anyone have any
suggestions. Thanks.
--
agilek9
 
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
Extracting time (hr:min) from date/time format lawandgrace Excel Discussion (Misc queries) 4 August 18th 09 05:21 PM
Comparing 2 files on date/time stamp, and based time difference do a subroutine [email protected] Excel Programming 1 September 28th 07 03:53 AM
Date-Time Stamp [email protected] Excel Discussion (Misc queries) 1 September 27th 06 02:37 PM
Extracting Time from a cell that has both the date and the time Hani Muhtadi Excel Discussion (Misc queries) 3 September 9th 05 10:59 AM
Date time stamp Frank Kabel Excel Programming 3 March 1st 04 08:56 PM


All times are GMT +1. The time now is 04:08 PM.

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"