Hi Richard

Try
=INT(SUM(HList!D:D)/8)&"Days "&MOD(SUM(HList!D:D),8)&" hours"

--
Regards

Roger Govier


"Richard" <Richard@discussions.microsoft.com> wrote in message
news:679C5DC1-A186-4BEC-82E3-67404D67086F@microsoft.com...
> If you're working in hours, say 8 hour increments. How would you write
> the
> formula to reflect every 2 hours instead it's displaying halves and
> quarters(.50 and .25) I'd like for it to display (.2 hrs or .4hrs or
> .6hrs)
> Example: If I've schelduled or taken 42 hours vacation and I have 20
> days
> available. I'd like the results to display ( 5 days and 2 hrs) used.
> (14 days
> and 6 hrs available) This formula works fine for the scheduled
> vacation but
> gives .50, .25 results =SUM(HList!D:D)/8 This formula works fine for
> the
> available vacation but still gives .50, .25 results
> Thanks in advance!