| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time frame conversion
Hi All,
I am using Excel 2003 and am wondering if there is a way to change the way Excel displays time. For example, now it is based on 24 hours as opposed to 12 hours so when I put in 1:00 the cell sees it as 1:00AM. I will need to put in 13:00 for the cell to show it as 1:00PM. If there is anyway to do this, I would appreciate any helpful advice. Thanks, LaurenM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Frame | Excel Discussion (Misc queries) | |||
| extract date between a given time frame | New Users to Excel | |||
| How do I sum within a set time frame from the current date? | Excel Worksheet Functions | |||
| How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
| 3 Time frame | Excel Worksheet Functions | |||
Threaded Mode
