I am using excel to query DB2. The field in DB2 Elapsed_Time has been
calculated from a End_Date_Time Start Date Time. The Problem is that excel
treats this value 00:00:00 as mm/dd/yyyy 00:00:00 AM/PM and there is nothing
I can do to change the format once it is in Excel. Right now I have reverted
to querying the Start/End Date Time and performing the calculation in excel
and formating as an elapsed time. I am using the Microsoft Query Wizard from
excel.

Unfortunately that will not work for some of the data as CPU Elapsed Time is
calculated and there is no CPU Start/Stop Date Time values it has been
summarized in the database. I am totally stumped :(

We have a query gateway (Web tool) and if I use that to query DB2 and export
to excel it works fine (elapsed time can be formatted as elapsed time). So
the issue seems to be in the query return from query manager but I cannot
find any way to format using the query manager application.

Any help would be awesome.