G
Guest
Hello everyone.
I have a cell that calculates overtime hours, from a sum of 8 other cells.
4 of these cells rely on another cell (R4) that contains the number 37.50 or
40. (which represents 5 days at 7.50 hours or 5 days at 8 hours)
I would like to like change that one cell to two new ones.
The first would contain the whole number of days available.
The second would contain the fraction of a day in hours. (This would not be
more than 7.5 or 8 depending on the value of R4.
eg. R4=40
old cell value = 29.50 (29 days & 4 hours)
new cell Z1 = 29
new cell Z2 = 4
Hoping you can understand my great logic.
Thanking you in anticipation.
I have a cell that calculates overtime hours, from a sum of 8 other cells.
4 of these cells rely on another cell (R4) that contains the number 37.50 or
40. (which represents 5 days at 7.50 hours or 5 days at 8 hours)
I would like to like change that one cell to two new ones.
The first would contain the whole number of days available.
The second would contain the fraction of a day in hours. (This would not be
more than 7.5 or 8 depending on the value of R4.
eg. R4=40
old cell value = 29.50 (29 days & 4 hours)
new cell Z1 = 29
new cell Z2 = 4
Hoping you can understand my great logic.
Thanking you in anticipation.