Hi Richard

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

--
Regards

Roger Govier


"Richard" wrote in message
...
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!