Forum Discussion
Need assistance with converting hours into days
mtarler Hello, thank you for your reply.
Please see attached the spreadsheet i'm trying to create for my employees hour control and calculation of both hours worked, I need a formula that would convert these hours into days (each 5h is 1 work day) and also allowing me to calculte the payment based on the days worked.
I'm currently working on June (lines 63-73), it' in portuguese but it's basically resumed into the sum of the month's worked hours into a cell where it shows the total amount of normal hours, extra hours..
Then I would need the cell called DIAS to have a formula that would calculate the total amount of hours into days (5h equals to 1 day) and another cell where a formula would use the amount of days worked and multiply the hours by the daily salary (or divide it) in order to know how much should we pay each month.
thank you
I don't know what you want to do about partial days. right now I see 20 hours which is exactly 4 days but what if it was 21 hrs? should it ROUND off =ROUND(B73/5,0) or just cut off the excess like INT(B73/5) or leave the fraction as is