deviding hours

[Guest]

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?

 

[Boris]

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?

If you make the sum in format hh:mm, Excel will add a day for every 24
hours, so you will end up in less hours.
I would make calculations with hour values only, so INT(A1/7) will work,
and for presentation purposes only convert to hh:mm format.

HTH,
B.

 

[rshewade]

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?

If you make the sum in format hh:mm, Excel will add a day for every 24
hours, so you will end up in less hours.
I would make calculations with hour values only, so INT(A1/7) will work,
and for presentation purposes only convert to hh:mm format.

HTH,
B.

Forward me the sample file, i will help you

 

[Niek Otten]

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

|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?

 

[Guest]

So if your total hours is 34:00 you want to convert this to 4 days 6:00?

Try

=INT(A1*24/7)&" days "&TEXT(MOD(A1,"7:00"),"hh:mm")