Thread
:
Excel AM/PM Formatting
View Single Post
#
2
Posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
Posts: 35,218
Excel AM/PM Formatting
I'm betting that those entries aren't really times. Excel sees them as strings.
Is select the range to fix and
edit|Replace
what: AM
with: _AM (where _ represents a space)
replace all
And do the same thing with PM and _PM.
Once you do that, excel will see them as times and you can format the cells as
hh:mm:ss to get the format you want.
wrote:
Hi
I have a Crystal Reporting database that generates sign in and sign out
times for call centre staff, which I can export into Excel. The problem
is that once the time exceeds 12 noon it formats it as PM (in the
12hour clock format) instead of PM in the 24hours clock format.
Eg.
Sign In time Sign Out Time
09:47:13AM 01:45:01PM
How can I get excel to convert this time (as above) to show 13:45:01
Any help would be gratefully received.
Thanks
Coolkat
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson