M MWRhino Sep 19, 2008 #1 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?
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 Sep 19, 2008 #2 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
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
