In the screen shot below, cell CSM5 calculates (in number of days, hours & then min) an employees time of seniority (from their original date-of-hire until the time of their release of employment.)
The formula in cell CSM5 is: =INT(CSM6-CSM7)&" : "&TEXT(CSM6-CSM7, "h:m")
in the screenshot below, CSM5's (highlighted in yellow) formula returns the value of: 894 days, 9 hours and 35 min.
Cell CSL13 (also in highlighted yellow) gives the value of CSM5 represented as: =CELL("contents", CSM5)
Now we've arrived at my request... I would like the cell adjacent to CSL13 (which is CSM13, highlighted in green) to show the value of CSL13 represented in # of days, hours and min... PLUS 1 MINUTE.
CSL13 = 894: 9:35, and I need CSM13 to equal 894: 9:36
I need this so that I can have my VBA code sort all of the employees on the worksheet by the value represented their tenure when they worked here... the "plus 1 MINUTE" is needed in order to keep all the all the names together after code runs the sort... You see, each employee name (listed in row 1, horizontally) is represented by TWO columns, the column showing their name, column CSL in the example screenshot, as well as the column adjacent to it which is normally hidden... column CSM in my example.
Currently I can sort the worksheet by name or by the date when they left (termination date.) But a need recently arose where I need to be able to sort them by the amount of tenure they obtained while they worked here.
here's the worksheet showing all names sorted alphabetically:
and here's the worksheet showing everyone sorted by their term'd date:
this is just some extra (and unnecessary, actually) information I wanted to add so that what I am requesting hopefully makes sense in the correct context and what fits my particular worksheet needs given with how its laid out... usually someone, & out of a kind gesture to help me, will question why the heck I am doing it this way... lol which very well may still happen, but at least now everyone can see how this particular application functions. (and believe me, I am SURE that I am doing some things in a rather unorthodox manner and may not be the most sufficient or best way to do something.. .and I am always open to hearing suggestions or other alternatives to perform whatever function I may be trying to or am performing here...) so thanks for all/any assistance or help
The formula in cell CSM5 is: =INT(CSM6-CSM7)&" : "&TEXT(CSM6-CSM7, "h:m")
in the screenshot below, CSM5's (highlighted in yellow) formula returns the value of: 894 days, 9 hours and 35 min.
Cell CSL13 (also in highlighted yellow) gives the value of CSM5 represented as: =CELL("contents", CSM5)
Now we've arrived at my request... I would like the cell adjacent to CSL13 (which is CSM13, highlighted in green) to show the value of CSL13 represented in # of days, hours and min... PLUS 1 MINUTE.
CSL13 = 894: 9:35, and I need CSM13 to equal 894: 9:36
I need this so that I can have my VBA code sort all of the employees on the worksheet by the value represented their tenure when they worked here... the "plus 1 MINUTE" is needed in order to keep all the all the names together after code runs the sort... You see, each employee name (listed in row 1, horizontally) is represented by TWO columns, the column showing their name, column CSL in the example screenshot, as well as the column adjacent to it which is normally hidden... column CSM in my example.
Currently I can sort the worksheet by name or by the date when they left (termination date.) But a need recently arose where I need to be able to sort them by the amount of tenure they obtained while they worked here.
here's the worksheet showing all names sorted alphabetically:
and here's the worksheet showing everyone sorted by their term'd date:
this is just some extra (and unnecessary, actually) information I wanted to add so that what I am requesting hopefully makes sense in the correct context and what fits my particular worksheet needs given with how its laid out... usually someone, & out of a kind gesture to help me, will question why the heck I am doing it this way... lol which very well may still happen, but at least now everyone can see how this particular application functions. (and believe me, I am SURE that I am doing some things in a rather unorthodox manner and may not be the most sufficient or best way to do something.. .and I am always open to hearing suggestions or other alternatives to perform whatever function I may be trying to or am performing here...) so thanks for all/any assistance or help
