So, perhaps a kind-hearted Excel expert can guide me to a solution?

My cell formula reads:

=SUM(AE6/G111+AG6)

And the formatting of the cell is:

CUSTOM formatting

#" Days" ?/?" Hours"

Now this is how it's displaying:

Say the calculation AE6/G111= 1 .... and the fraction in cell AG6=0

Then my result will show:

1 [ SPACE ] Hours

BUT ... (with the same calculation) ... say the calculation AE6/G111= 1 ... and the fraction in cell AG6=1/2

Then my result will show:

1 Days 1/2 Hours

Do I not have something formatted properly?

How can I get the result to always read properly even if the result equals ZERO?

i.e.

0 DAYS 0 Hours

0 DAYS 3/4 Hours

1 DAYS 0 Hours

Cheers!