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.

Exporting time from cell in 24 hr format
 

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.

Exporting time from cell in 24 hr format
 

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.

Exporting time from cell in 24 hr format
 

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.