Extracting the Time from a Date/Time Stamp

A

agilek9

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.
 
J

JE McGimpsey

One way:

A1: 20 Nov 2008 10:32:01
B1: =INT(A1)
C1: =A1
D1: =MOD(A1,1)

Format B1 as date
Format C1 as Format/Cells/Number/Custom, "ddd" or "dddd"
Format D1 as Time


Format B1 as time.
 

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

Time/Date Stamp 3
Look up file by date/time stamp. 1
Static Time/Date Stamp 2
VBA time date stamp 3
date stamp 4
macro to date stamp to the right of the macro command button 4
Date/time Stamp? 7
Excel Excel 2010 Time Stamp Button Help 1

Top