Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting times
I'm trying to convert times in a spreadsheet (1:15:00 PM
to 0115P and 11:45:00 AM to 1145A) but am not having much luck. Any suggestions on a formula to make this conversion would be greatly appreciated. Thanks for the help....JT |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting times
Hi JT
Time is time, what you see is simply a graphical presentation of it. I take it you mean that 1:15:00 PM and 0115P is the very same value, so no conversion should be done. Just format the cell as custom format hhmmA/P . HTH. Best wishes Harald "JT" skrev i melding ... I'm trying to convert times in a spreadsheet (1:15:00 PM to 0115P and 11:45:00 AM to 1145A) but am not having much luck. Any suggestions on a formula to make this conversion would be greatly appreciated. Thanks for the help....JT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Times | Excel Worksheet Functions | |||
Calculation of hourly rate times hours times 1.5 | Excel Worksheet Functions | |||
How are relay leg times or driving times entered and totaled? | Excel Worksheet Functions | |||
Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
Converting Times | Excel Programming |