how do I convert a date and time column to a time column

T

thdorsky2

Do you know how I can convert a column with 01/02/2004 9:14:12 AM to a time
(09:14:12)

thx..
 
P

Peo Sjoblom

Just use a format like hh:mm or hh:mm AM/PM assuming it is real numeric
date/time
if text you can use a help formula

=--MID(A1,FIND(":",A1)-2,32)

copy down/across and format as hh:mm or hh:mm AM/PM
 

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_report_date-wise_employee-wise 6
separating date and time 5
How to get largest date from a Vlookup 1
Multiple Creteria Lookup(Between Dates) 8
Delete Text in Multiple Cells 3
IF ARRAY with multiple conditions. 1
Modifying a complex date formual to count months 4
How do I set up a formula to give me an average based on IF? 1

Top