My guess is that he has a typo, maybe it should be 18/52

converted to hours is 00:20:00

--


Regards,


Peo Sjoblom

"T. Valko" wrote in message
...
Question 1:

Assuming the cells will only contain numbers...

Assuming the value is 10...

=10*IF(A1,260,IF(B1,52,IF(C1,12,0)))

Question 2: not following you on this one!

--
Biff
Microsoft Excel MVP


"se7098" wrote in message
...
i have a 2 part question:

i need a formula that will look for a value in a particular cell then
based
on which column it is found in multiply by the corresponding value to
return
the correct product

i.e., look across columns a, b & c...if it finds a number in a multiply
by
260 if it finds a number in column b multiply by 52 if it finds a number
in
column c multiply by 12

there will never be a number in more than one column




2nd question...how can i translate a number into hours broken down by
quarters

18 hours*52 weeks = .346...i need .346 converted to hours or rounded up
to
the nearest quarter hour