How do I enter hours and minutes (54:45) and get the decimal equivalent? (i.e. 54.75)
S Sharon Sep 24, 2003 #1 How do I enter hours and minutes (54:45) and get the decimal equivalent? (i.e. 54.75)
B Biff Sep 24, 2003 #2 Hi Sharon, Try this: =A1*1440/60 A1 holding the value formatted as [H]:mm Biff
P Peo Sjoblom Sep 24, 2003 #3 Why not just =A1*24 ? -- Regards, Peo Sjoblom Biff said: Hi Sharon, Try this: =A1*1440/60 A1 holding the value formatted as [H]:mm Biff -----Original Message----- How do I enter hours and minutes (54:45) and get the decimal equivalent? (i.e. 54.75) . Click to expand... Click to expand...
Why not just =A1*24 ? -- Regards, Peo Sjoblom Biff said: Hi Sharon, Try this: =A1*1440/60 A1 holding the value formatted as [H]:mm Biff -----Original Message----- How do I enter hours and minutes (54:45) and get the decimal equivalent? (i.e. 54.75) . Click to expand... Click to expand...
