Toughy for me, easy for you

[craigwojo]

Hi everyone,

I'm stuck without a clue on how to do something . I have
business that produces engraved tags, and many times I need a tim
factor for the production of these tags. Here's what I have.

If .125 (12 point font) (on the basis of 1" = 96 point) of an inc
takes 38 seconds to be engraved, I need a formula that all I need to d
is input the font size (point size on the basis that 96 points is 1"
for the tag and the formula will figure the time. Also there is a
input cell for number of lines per tag which will be the input * th
above formula. (I can figure that one out )
Note: Remember, .125 of an inch takes 38 seconds to engrave. .125 is
12 point font.

Something like:
Column A: Text Size (input)
Column B: How long (in time) per line of text (formula)
Column C: Number of Lines (input)
Coulmn D: Time per tag (formula) Column B * Column C

Thank you,
Crai

 

[Jason Morin]

In col. B:

=(A1/0.125)*38

This will return in the answer in seconds. To see it in
min/sec., use:

=((A1/0.125)*38)/(60*60*24)

and format the col. B as [mm]:ss.

HTH
Jason
Atlanta, GA

-----Original Message-----

Hi everyone,

I'm stuck without a clue on how to do

something . I have a