deviding hours
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")
"tamara" wrote:
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?
|