Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
deviding hours
On Sat, 10 Nov 2007 00:02:00 -0800, 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? 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
deviding hours
On Nov 9, 9:12 pm, Boris wrote:
On Sat, 10 Nov 2007 00:02:00 -0800, 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? 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
wages - multiply hours and minutes by number of hours worked | Excel Discussion (Misc queries) | |||
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
how to add hours and show actual hours not decimal numbers | New Users to Excel | |||
Problem converting Hours to Days, Hours, Minutes | Excel Worksheet Functions | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions |