Thankyou much.. have been asking this question since long time ago.. and
have just realized the following today. I am not that quick with these
functions, even mine; IF you could tell me if they do the same thing / in
couple words how yours works.
(I think your first example will suite me, but will keep the other in mind).

Is your formula not dependant on a stop time (i.e.: 1600 hrs..)
I am I doing the same thing with:

If the following is correct for a "relative position" equation, in percent:
=(last/from)/(to-from)*100

then trying to find the acceptable volume quantity level, for a percentage
position of the time-of-day (9:30am-4pm / 1600 hrs), might be:

=CT9(((($DC$3-TIME(9,30,0))/(TIME(16,0,0)-TIME(9,30,0)))*100)%*CU9)

or as told, I only need:
=CT9(($DC$3-TIME(9,30,0))/(TIME(16,0,0)-TIME(9,30,0)))*CU9

where CT9 is the Last Quantity, $DC$3 is a time stamp (with: Cntrl+Shift+;
),
and CU9 is the Total Quantity being compared to.




"Sandy Mann" wrote:

With the time, (10:00am as an XL time not 10am) in say - A10 and the total
in B20 then the formula:

=(A10-"9:00")*24/7*B20

and format as General or Crrency as appropriate.

If the time in the last value in Column A and the *total* is the last value
in Column B then use:

=(LOOKUP(100^100,A:A)-"9:00")*24/7*LOOKUP(100^100,B:B)

If you want if to update at each sheet calculation the use:

=(LOOKUP(100^100,A:A)-"9:00")*24/7*LOOKUP(100^100,B:B)

=(LOOKUP(100^100,A:A)-MOD(NOW(),1))*24/7*LOOKUP(100^100,B:B)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"nastech" wrote in message
...
(070709) Divide # by portion of the day??? compare to previous total
column,
thanks

is there a formula for calculating what a portion of the day's value
should
be, if you have a total quantity to start from (for numbers..), so: ??

9am - 4pm, if it is 10am, 1/7th of current count in column AA, is =
1/7th
of col AB