How do I incorporate letters as numbers in a formula?

M

MWRhino

On a roster, D = 12 hour day and N = 12 hour night. How do I get Excel to
calculate D's and N's as numbers?
 
M

Mike H

Hi,

Somewhere out of the way do this
Insert|Name|Define
Enter D
In another cell
Insert|Name|Define
Enter E

Put the number 12 in each of these cells

You can now refer to D & E and they will be treated like values. i.e.

=D+E returns 24

Mike
 
Top