| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
time format
I have a column for time in my spreadsheet. The value are as follows:
4:10:18 PM 10:29:30 AM 1:57:33 PM 10:13:20 AM I would like to programatically change them to the following values: 04:10 PM 10:29 AM 01:57 PM 10:13 AM I'm having trouble getting the results I want. When I fill a variable with the hour for 4 PM, the value is 16. Any suggestions would be appreciated. Thanks for the help. -- JT |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
time format
did you try to refromat the cell using the format menu - cells - number -
date. there are lots off date formats that are avvailable. "JT" wrote: I have a column for time in my spreadsheet. The value are as follows: 4:10:18 PM 10:29:30 AM 1:57:33 PM 10:13:20 AM I would like to programatically change them to the following values: 04:10 PM 10:29 AM 01:57 PM 10:13 AM I'm having trouble getting the results I want. When I fill a variable with the hour for 4 PM, the value is 16. Any suggestions would be appreciated. Thanks for the help. -- JT |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| How to type format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions | |||
Linear Mode
