A
Ab
I am trying to figure a productivity % by dividing a sales
# by a # of hours, but Excel is not reading the hours as a
number.
Example: my total hours are 106:54:48, but the actual cell
contains 1/4/1900 10:54:58 AM. When I manually enter 107
hours (rounded up) I get the correct answer to the
formula, however I am dealing with hundreds of lines and
cannot manually change every one for the formulas to calc
properly.
I want to convert the cell content of 1/4/1900 10:54:58 AM
to what is actually displayed, 106:54:48, and calculate my
productivity %.
Any help on setting this format?
Thanks!!
# by a # of hours, but Excel is not reading the hours as a
number.
Example: my total hours are 106:54:48, but the actual cell
contains 1/4/1900 10:54:58 AM. When I manually enter 107
hours (rounded up) I get the correct answer to the
formula, however I am dealing with hundreds of lines and
cannot manually change every one for the formulas to calc
properly.
I want to convert the cell content of 1/4/1900 10:54:58 AM
to what is actually displayed, 106:54:48, and calculate my
productivity %.
Any help on setting this format?
Thanks!!