Late Time durations under one hour export incorrectly to CSV in AAI

Products

• Automation Analytics & Intelligence

Issue/Introduction

When exporting the Jobstream Definitions table to a CSV file in Automation Analytics & Intelligence (AAI), duration values in the Late Time column that are less than one hour do not display correctly when opened in Microsoft Excel.

• Example: A 30-minute duration appears as 30:00:00 in Excel instead of 00:30:00.
• Web UI Behavior: The value correctly displays as 30:00 in the AAI Web interface.
• Durations ≥ 1 Hour: These export correctly in a three-part format (e.g., 1:10:00).

Environment

• Automation Analytics & Intelligence (AAI) 24.4 and below.

Cause

This is caused by a product defect (DE193742).

The AAI backend API returns sub-hour durations in a two-part MM:SS format (e.g., 30:00). While the Web UI renders this string directly, Microsoft Excel uses a standard time heuristic that interprets a two-part XX:XX string as Hours:Minutes. Consequently, Excel treats "30:00" as 30 hours and 0 minutes, leading to the incorrect display of 30:00:00.

Resolution

This issue is scheduled to be resolved in AAI version 26.0.0. The fix normalizes all duration strings to a three-part HH:MM:SS format (e.g., 00:30:00) before export, ensuring Excel interprets the values correctly.

Workaround

If an immediate correction is needed in the exported report, manually format the cells in Excel:

1. Highlight the affected Late Time column in Excel.
2. Right-click and select Format Cells....
3. Go to the Number tab and select Custom.
4. In the Type field, enter [h]:mm:ss or hh:mm:ss.
5. Click OK. This will force Excel to display the values as minutes and seconds.