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