How to convert Person days from hours to days ?

[Nur1]

Hi Community,

Currently, we have an OOB field called person days in resource_aggregate_monthly table with actual time spent on Project, M&S in person days unit.

I need to have the new person days field in Time Card table where the value in Person Days is computed based on Total field. The Total field is in Hours, how to convert from hours to days ?

Please help with the script. Thank You.

[Tony Chatfield1]

Hi, I would simply divide the total number of hours by the number of hours in your business day, using whichever rounding\standardization formats you required to get the result your require IE to 2 decimal places or rounded etc.

[Dhiren Aghera]

Hi Nur,

This is how I would calculate person days based on the available hrs of the resource. Here as Resource 1 is available 7hrs a day which makes is 35 Hrs a week against weekly schedule of 40Hrs the person days for Reosource1 reduces from 5 to 4.38 for that week.