I need to create a spreadsheet to calculate the annual time share
percentages that are allocated to the two parents in a child custody
case.

The time throughout the year is typically allocated in three block:
vacation (about 75 days), holidays (about 38 days), and everything
else (about 252 days, when school is in session). The total days must
sum to 365.

Each of the blocks may be specified either as a percentage or as a
number of days. For example, it might be something like this. There
are 6 input cells: the first 2 cvalues in the first 3 rows. The rest
are calculated.

Father Mother Father% Mother% Block Days
30% 70% 30% 70% School time 252
20 days 55 days 27% 73% Summer time 75
50% 50% 50% 50% Holiday time 38
115 days 250 days 32% 68% Totals 365

The school time schedule can also be entered as how many days each
parent gets in 1, 2, or 3 weeks.

Father Mother Father% Mother% Block Days
3.5 days 10.5 days 25% 75% School time 252
20 days 55 days 27% 73% Summer time 75
50% 50% 50% 50% Holiday time 38
102 days 263 days 28% 72% Totals 365

I would like to set up the 6 input cell so the user could enter the
parameter as a percentage ("35%") or a number of days ("22 days") and
have the spreadsheet figure out what to do.

Do I need to write a macro?

Is there a better wauy to approach this?


--
Running Excel 2000 SP-3 on Windows 2000