Thread: deviding hours
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tamara Tamara is offline
external usenet poster
 
Posts: 17
Default deviding hours

I calculate the montly hours leaves for the employees, I make the sum of the
daily leaves and the format [hh]:mm, then i want to convert the sum to days &
hours, every 7 leaves hours = 1 day so I put the formula: =int( A1/7) but the
result is always 0, so what should I do?