If we assume the hour integers are Q3:Q4 etc... then it will be simplest to work from those:
You can simplify your individual manday calcs along similar lines:
If you were to /or have already activate(d) the Analysis ToolPak Add-In you might consider using DOLLARFR:
for individual day:
For aggregate:
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.
Bookmarks