How do I incorporate letters as numbers in a formula?
 

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?

How do I incorporate letters as numbers in a formula?
 

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

"MWRhino" wrote:

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?