Symptom
Hours and billable hours appears incorrect when you export the time recordings under activity list for project
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Project Management work center
- Go to the Projects view and select the relevant Project
- Select Activity List and select the Period Selection (Date From / To)
- Select Go under the Time Recordings section
- You can see the Hours and Billable Hours are correct
- Select Export To Microsoft Excel®
- In the export excel, you will see the incorrect hours
Cause
The export data depends on the time format which you have selected in your personalization settings. If you have set the time format to 12 hrs., then you
will see the converted value in the hour's column of the exported excel
For Example:
You have 14 hrs entered in the time sheet and the same will appear in the Time Recordings section under Activity List. You have time format defined for 12 hrs. When you export the list, system will calculate the hours as below;
14 hrs. (Employee time) - 12 hrs. (Time format) = 2 hrs. (Display hours in the export excel)
Resolution
You must change the time format to 24 hrs. and then system will show the complete hours in the exported excel
Keywords
Export time recordings to excel from activity list; Export time recordings; , KBA , export time recordings to excel , export activity list data to excel , AP-PRO-PRJ , Project , Problem