I'm still working on this in order to come up with the desired format of
[N]d [N]h, so I'm doing the bump thing to see if there are any fresh,
new ideas. I had to make a slight correction in the formula because I
noticed it wasn't dispaying the eight-hour remainder correctly.

So, here's what I am faced with once again: I'm trying to take a total
number of man hours and convert it into man days, based on an eight
hour work day, with the remaining hours displaying as well. In other
words, I have the following data:

A1: 405.20h* [#,##0.00\h]*
A2: =IF(A10,(INT((A1/24)*3)&"d "&ROUNDDOWN(MOD(A1,24/3),0)&"h"),"")

The main parts of the formula are colored; I used a rounding function
to keep things simple, and wrapped it all in an IF statement to ensure
the cell would just remain blank if there was no man hour value to
calculate, instead of displaying zeros.

That formula displays the result, correctly, as 50d 5h, or 50
eight-hour man days, and 5 man hours. The problem I'm having is my
formula essentially turns the value in A1 into a text value in A2 which
can no longer be used in calculations. I'm pulling my hair out trying to
display that exact same value, "50d 5h", as a custom number format so
it'll still remain an actual number value that can be processed in cell
calculations.

As always, I appreciate every reply, thanks in advance for everyone's
help!


--
centerNegative
------------------------------------------------------------------------
centerNegative's Profile: http://www.excelforum.com/member.php...o&userid=24921
View this thread: http://www.excelforum.com/showthread...hreadid=384618