Exporting time from cell in 24 hr format

[Guest]

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.

 

[Guest]

Sorry if I'm confused here, but is this an XML question or an Excel question?

Can you post the XML you're using?

Dave

 

[Guest]

Here is the XML That I must input the time in a 24 hr format. The reason I am
using the Excel spreadsheet is because I am then able to set up a formula
working with the current time and then modify it to meet my needs, all
depending upon the particular test I am running. The XML is then sent over a
bus via a XSD script.

<?xml version="1.0" encoding="utf-16"?><WFACUpdateTroubleTicketRequest
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://www.qwest.com/XMLSchema"><WFARegion></WFARegion><RACFID><AuthorizationInfo
xmlns="http://www.qwest.com/XMLSchema/BIM"><UserId></UserId><Password></Password></AuthorizationInfo></RACFID><REQUEST><CONTRACT></CONTRACT><FUNCTION></FUNCTION><PASSWORD></PASSWORD><USERID></USERID><VERSION></VERSION><ZONE></ZONE></REQUEST><TRFCTREQ><CUR_GRP></CUR_GRP><CUR_POS></CUR_POS><DEST></DEST><DT_STAMP></DT_STAMP><END_DT></END_DT><END_TM></END_TM><FCT></FCT><START_DT></START_DT><START_TM></START_TM><TR></TR></TRFCTREQ></WFACUpdateTroubleTicketRequest>

Hopefully this explains things a bit more.

 

[Guest]

I beleive I have figured this out and that deals with converting the time
after making the necessary calculations to a TEXT field. Now it is doing what
I was tryiing to accomplish.