If sum

N

Neil Greenough

Column A = start time
Column B = finish time
Column C = type of shift (either 'meeting' or 'teaching' - selected from
dropdown menu)
Column D = (see below)

..... In column C, I would like the following to be worked out....

I would like the difference between column B and A to be worked out (ie. the
total amount of hours worked) and then I would like this to be multiplied by
10 if Meeting is selected in column C, or 17 if Teaching be selected in
Column C

Thanks all
 
J

JulieD

Hi Neil

in D1
=IF(C1="Meeting",(B1-A1)*24*10,IF(C1="Teaching",(B1-A1)*24*17,""))

Hope this helps
Cheers
JulieD
 
N

Neil Greenough

Thanks Julie and other person

Neil

JulieD said:
Hi Neil

in D1
=IF(C1="Meeting",(B1-A1)*24*10,IF(C1="Teaching",(B1-A1)*24*17,""))

Hope this helps
Cheers
JulieD

multiplied
Click to expand...
 
M

Myrna Larson

Or, for a bit less typing <g>

=(B2-A2)*24*IF(C2="Meeting",10,17)

My assumption is that the value in C2 is selected from a dropdown list where
the user can't enter new values, so the only two possible entries are Meeting
and Teaching.
 
Top