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!

## Bookmarks