Drop AM and PM from date

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

Guest

The text in the cell reads:
05/23/2005 17:23:31

but the actual data that shows in the formula bar at the top reads:
5/23/2005 5:23:31 PM

I need the data to reflect the first format. How?
 
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

Subtracting time...again 2
Workday Formula to include date 0
Rounding Seconds in 4/21/2010 4:30:23 PM 3
How do I find a match for three variables to determine the result? 4
How to enter start and end date/time in excel based on some specific value. 7
Problem formatting dates from CSV file 2
Sum quantities per hour from inconsistent intervals on a 24hr cloc 4
Summing clock in and out by date 1

Back
Top