| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Exporting time from cell in 24 hr format
I know how to make a cell read the time in a 24 hour format of hh:mm. But the
issue is that I need to pull that same exact format and place it into a XML script. Currently when this occurs it changes it to a 12 hour format. The XML script I am having to populate also will not accept the use of the @ symbol nor AM or PM, there fore to get the accurate time I must input into the XML as a 24 hour. Any suggestions on how I might be able to accomplish this task? The AM times do not create an issue its when I hit the PM times that the XML manages to read say 17:00 as 05:00 then the application I am sending this to reads it as 5:00 AM instead of 5:00 PM that I wanted. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I convert numeric 0510 to time 05:10 by custom cell format? | Excel Discussion (Misc queries) | |||
| Format cell as military time | Excel Discussion (Misc queries) | |||
| how do I format the sheet so that I may click on 1 cell at a time | Excel Worksheet Functions | |||
| Excel Cell Format for Time | Excel Discussion (Misc queries) | |||
| calculating with a time format cell | Excel Worksheet Functions | |||
Threaded Mode
