Hi LurfysMa:

What an interesting name.

I would suggest having a data area where you enter the data and say if it is
percentage or days.

You can then have a report area where you present the answers.

The cell (in say A1) for percentage or days could be P or D and then in your
some you use an if statement:

=IF(A1="P",365*A2,A2)

for days etc.

and for percentages:

=IF(A1="D",A2/365%,A2)

You need to consider about leap years.

Hope this gets you started.

And lets see how you get on.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"LurfysMa" wrote:

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