Time Functions

[Allan]

I have been toying around with almost all of the time functions. I don't
seem to have an answer.

I am building a weighted score for a set of data that gets reported in
different formats, numbers and time. Something like:

(reported-number1 *weight-of-number1) + (reported-number2
*weight-of-number2) + (reported-number3 *weight-of-number3) = SCORE.

That is all well, and good, except I am not understanding how to score the
time. There is a "goal" time and an actual time. How do I subtract time?

[I know if I have two "time formatted" cells, I can just subtract the cells,
voia la.] But how do I do that in the middle of a formula? For example, if a
task was supposed to be done by 7:00 PM, and it was done by 8:15 PM, I would
like to have returned either 1.25 (hrs) or 75 (minutes). Then I can assign a
weight, in the middle of my formula, and off we go...
Thanks for all your help!

 

[Leo Heuser]

Allan

One way is to use

TIME(8,15,) - TIME(7,,)

 

[Frank Kabel]

I have been toying around with almost all of the time functions. I
don't seem to have an answer.

I am building a weighted score for a set of data that gets reported in
different formats, numbers and time. Something like:

(reported-number1 *weight-of-number1) + (reported-number2
*weight-of-number2) + (reported-number3 *weight-of-number3) = SCORE.

That is all well, and good, except I am not understanding how to
score the time. There is a "goal" time and an actual time. How do I
subtract time?

[I know if I have two "time formatted" cells, I can just subtract the
cells, voia la.] But how do I do that in the middle of a formula? For
example, if a task was supposed to be done by 7:00 PM, and it was
done by 8:15 PM, I would like to have returned either 1.25 (hrs) or
75 (minutes). Then I can assign a weight, in the middle of my
formula, and off we go...
Thanks for all your help!

Hi allan
try
=((B1-A1)*weight_1)+((B2-A2)*weight_2)+....+((Bx-Ax)*weight_x)

Wehere Bn and An are times
Frank

 

[Allan]

PRESTO! Thanks a million. (that was a fast reponse, too)