Re: HELP!need to determine price based on time to complete using Min. Hour. And days

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 19:28:54 +0100

Hi
sorry for confusing you (should have stated day_amount, etc.). Just use
these values in the formulas i provided to you. So try
1. costs for the days:
=INT((A1*24)/T12)*100
2. costs for the hours
=INT(MOD(A1*24,T12))*50
3. costs for the minutes
=((MOD(A1*24,T12))-INT(MOD(A1*24,T12)))*60*10

ccording to your example. Just replace my dummy 'rate variables' with
your respective dollar amount for hours/days/minutes. 

--
Regards
Frank Kabel
Frankfurt, Germany
> First, thanks so much for everything.. But, either I am way wrong, or
> we are Thinking about 2 different things.  For the cost to produce,
> We do not have a RATE we have a Dollar Amount.  So say 100/day
> 50/hour/10/min (just to simplify) are the fixed expenses.  What i
> need to do is say it takes 2 days, 1 hours and 10 minutes to
complete,
> The amount i would need to get would be 260.
>
> I don't think i had made that very clear.
>
>
> ---
> Message posted from http://www.ExcelForum.com/