Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel AM/PM Formatting
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Excel should be able to format 12-hour times without am/pm | Excel Discussion (Misc queries) | |||
Excel could not save all the data and formatting you recently ad.. | Excel Worksheet Functions |