Summing Durations Issue
I am looking to sum a durations column that has varied input including hours, days and weeks. However it sums the number instead of the indented values. Ex:
1h, 5d, 2w should sum up to*:151, but instead I get 8. Is there a way to convert all durations into hours and then sum? To make it more complicated I am using a report to then filter out hours that are not assigned to my team members, as that is the true sum I want.
Any help much appreciated. The duration column input is variable and will always have hours, days and weeks input, but impossible to predict otherwise I would just use a formula to convert to always convert to hours. Is there a formula that reads the duration value and then converts to hours based on the project settings?
*assuming project setting is set to 5 days a week 10 hours a day