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.

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
--
Brevity is the soul of wit.


"dhinrichs47" wrote:

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.

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.



"Dave F" wrote:

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
--
Brevity is the soul of wit.


"dhinrichs47" wrote:

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.

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.

"dhinrichs47" wrote:

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.



"Dave F" wrote:

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
--
Brevity is the soul of wit.


"dhinrichs47" wrote:

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.