deviding hours
Times in Excel are stored as fractions of a day and a day is stored as the number 1.
So multiply the hours by 24 and you get the number of hours as a number.
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"tamara" wrote in message ...
|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?
|