Removing characters from datetime field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an XL sheet with data in the format "07/07/2005 10:00:00". I need it
in the format "07/07/2005 10:00", so that I can create a pivot table with
the date and count of some records. How do I make the date in this format.
Tried the formatting, but it works incorrectly in the pivot table. Pls help...
 
Are you sure the raw data is really date/time?

If you put this in an unused cell
=count(a2:a99)
in a cell (use the correct range)

And this in another:
=counta(a2:a99)

do you get the same results?
 
tried the formula for a certain number of cells in the xl sheet. the results
that I got were the same.
 
When I had dates/times in my pivottable, I could select those cells in the
pivottable and format them the way I wanted.

But that didn't work for you???

What happened?
 
You must log in or register to reply here.

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

How to Round a Date to a Month 2
Number of hours between now and selected date 5
Combining 2 kinds of graphs [how?] 2
Formating time 2
Grouping dates in pivot table 3
Date formats 1
Conditional Formatting 1
Problem with times in pivot tables and graphs 2

Back
Top