Splitting a time formula in two.
 

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.
--
Big Rick

Z1: =INT(W1)
Z2: =MOD(W1,1)*R4/5

--
HTH

Bob Phillips

"Big Rick" wrote in message
...
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.
--
Big Rick

Once again, many thanks.
One day, I hope to be as half as good as you all.
--
Big Rick


"Bob Phillips" wrote:

Z1: =INT(W1)
Z2: =MOD(W1,1)*R4/5

--
HTH

Bob Phillips

"Big Rick" wrote in message
...
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.
--
Big Rick