In the pm_project table there are fields that refer to a quantity of hours as Type "Duration". Any field that contains some quantity of effort should be of type -- integer. For example, 8 hours of effort can be spread across an indeterminate number of hours of duration. This is also problematic when extracting this data because the duration fields are shown in seconds when exported to excel.
Duration fields store values in seconds, which makes exports messy. For effort fields, use Integer type. If you need duration in hours, convert seconds to hours when exporting or use a display script/UI logic to show hours instead of seconds
What I'm saying is that there is a flaw in the table design. It should NOT be a duration field. A duration is period of time (1 hour, two weeks, a year) any indication of effort is a quantity (integer) of units, in this case hours.
