Jul 02 2022 03:35 PM
Hello everyone,
I would need assistance, I need to find how to make a formula where I can:
- calculate how many days did someone work, based on the fact that 1 day of work corresponds to 5 hours and not 8H or 24H.
Thank you for your assistance.
Jul 02 2022 06:17 PM
Jul 03 2022 01:46 AM - edited Jul 03 2022 01:56 AM
@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
Jul 03 2022 11:30 AM