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.