| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can you convert 13:00 to 1:00 pm without the pm being displayed (.
I am trying to make an employee time sheet. I can calculate hours, etc., but
it would be better if the time sheet reflected 13:00 as 1:00 with the pm understood. Please help me with the solution. Thank you very much. -- George |
|
#2
|
|||
|
|||
|
You can just use a format like
h:mm AM/PM you can set that as default in windows under startsettingscontrol panelregional options/settings and use hh:mm:ss as opposed to HH:mm:ss Regards, Peo Sjoblom "Texas Rubberlip" wrote: I am trying to make an employee time sheet. I can calculate hours, etc., but it would be better if the time sheet reflected 13:00 as 1:00 with the pm understood. Please help me with the solution. Thank you very much. -- George |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use displayed value, not stored value? | Excel Worksheet Functions | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| Convert Time...!convert tenths of a second | Excel Discussion (Misc queries) | |||
| How to convert the table in word to excel sheet? | Excel Discussion (Misc queries) | |||
| Is there a formula to convert numbers to written text in Excel? | Excel Worksheet Functions | |||
Linear Mode
