My Oracle Support Banner

Units/Durations Change Decimal Places When Attempting to Import an Excel (.Xlsx) File Into P6 Professional (Doc ID 2405953.1)

Last updated on JULY 25, 2019

Applies to:

Primavera P6 Professional Project Management - Version and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version and later
Information in this document applies to any platform.


When attempting to import an .xlsx file into P6 Professional the original duration changes from 1.5h to 15h.

Note: When performing an xls export and then importing the same xls file back into P6 Professional the decimal placement changes


  1. Export duration/units to excel from P6 Professional
  2. Import the same XLS file from step 1. back into P6 Professional
  3. Observe that duration/unit decimal placement has shifted (i.e. 15h instead of 1.5)


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.