Man Day Calculation and Auto Sort

If we assume the hour integers are Q3:Q4 etc... then it will be simplest to work from those:

Please Login or Register  to view this content.

You can simplify your individual manday calcs along similar lines:

Please Login or Register  to view this content.

If you were to /or have already activate(d) the Analysis ToolPak Add-In you might consider using DOLLARFR:

for individual day:

Please Login or Register  to view this content.

For aggregate:

Please Login or Register  to view this content.

Regards your ordering question - can you explain with an example ?

You won't be able to sort the entry cells without intervention (ie sort command or use of VBA) - you could however sort the values in another range via formulae.

The formula for R3 would be as outlined:

Please Login or Register  to view this content.

If you then wanted to have total "Man Hours" hours & mandays in Q364:R364 respectively then

Please Login or Register  to view this content.

etc...

In terms of sorting - VBA required and not with Merged Cells.

Actually I goofed. I should have removed the column for Total Hours as they want to input man days instead. The calculation for R3 would sum from D3 to P3 and return a man day total. For example:

D3 = 24.3 = 24 man days and 3 hours (man days = 8 hours)
E3 = 16.7 = 16 man days and 7 hours
F3 = 57.1 = 57 man days and 1 hour
R3 = 98.3 = 98 man days and 3 hours

I hope this isn't as confusing to you as it is to me.

Thank you again for your help!

~ Brenda~

IMO even if you/they opt to enter D:P in terms of Mandays as described (as opposed to Hours) you would still be best served maintaining the Total Hours columns, you can calculate this figure off the manday values using:

Please Login or Register  to view this content.

at which point R3 remains as outlined previously:

Please Login or Register  to view this content.

If you remove the Total Hours columns and opt against Analysis ToolPak dependency (wise) then you're left with a certain amount of double evaluation.