| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Extracting the Time from a Date/Time Stamp
with date/time in A1:
=A1-INT(A1) and fomat as time -- Gary''s Student - gsnu200814 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Extracting the Time from a Date/Time Stamp
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. In article , agilek9 wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting time (hr:min) from date/time format | Excel Discussion (Misc queries) | |||
| Comparing 2 files on date/time stamp, and based time difference do a subroutine | Excel Programming | |||
| Date-Time Stamp | Excel Discussion (Misc queries) | |||
| Extracting Time from a cell that has both the date and the time | Excel Discussion (Misc queries) | |||
| Date time stamp | Excel Programming | |||
Hybrid Mode
