time formats using Excel 2010 Query

A

atm103

Having problems with the time format using query with an excel
worksheet...

I just started using excel 2010 (upgrade from 2003). I have a
worksheet with a column for time. The times are formatted as time
(ex. 10:30:00 PM - not text).

When I run a query all the times show up "1/0/1900 0:00". Then I try
to format those times they all show up as 12:00 AM or ZERO.

I can go back and change all the times to text, but this is a large
worksheet....then they don't sort correctly as text versus a number...

I did not have this problem with Excel 2003. I just want the times to
show up correctly in the query.

Any help would be appreciated. Thanks.

1/0/1900 0:00 instead of 4:30 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

Someone knows how to add hyperlinks to hours to schedule an appointment? 0
Amending meeting cancels all future meetings 0
Suming Up Time over the course of days 1
Calculate Face Time 4
Extracting just the time portion 6
Match function with time 3
How do I set focus (and select text) on a text box on a modeless userform? 0
Subtracting time...again 2

Top