Solved

Need help with excel

Posted on 2014-09-04
2
109 Views
Last Modified: 2014-09-04
I have an excel sheet.
Interval_PCFC_DateTime      Interval_PCFC_Date      Interval_PCFC_Time
2013-07-28 00:00:00              7/28/2013      
2013-07-28 00:15:00            7/28/2013
2013-07-28 00:30:00            7/28/2013

i retrieve Date portion from the Interval_PCFC_DateTime., just made a copy and formated as date
now i need to retrieve the time portion in the format hh:mm (no seconds)
Interval_PCFC_DateTime      Interval_PCFC_Date      Interval_PCFC_Time
2013-07-28 00:00:00              7/28/2013                      00:00
2013-07-28 00:15:00            7/28/2013                      00:15
2013-07-28 00:30:00            7/28/2013                      00:30

please help me with that
0
Comment
Question by:rfedorov
2 Comments
 
LVL 45

Assisted Solution

by:aikimark
aikimark earned 200 total points
ID: 40304972
do the same thing with the third column, except format it as "hh:mm"
0
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 300 total points
ID: 40304978
If this data is already in date/time format (assuming so since you were able to copy the values in column A to column B and reformat), then you should be able to do something similar in column C.  Just copy - or reference - the values in column A and reformat to "hh:mm":
date and time
Example file attached.

-Glenn
EE-Date-Time.xlsx
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now