I need the coding in order to quickly outline the following:
1. total hours/mins per week and also per fortnight
2. overtime hours/mins of anything over 9 hrs per day (part-timers only)
3. overtime hours/mins of over 5 hours worked without a break (casual & part time)
4. overtime hours/mins
5. Saturdays highlighted in yellow and Sundays highlighted in Green
I also need a quick way of deleting columns that I do not need. In this example, I do not need columns H-K; P-W; Y-AD.
Sheet1 is how the data is exported initially. Spreadsheet ppe [url removed, login to view] is how I edit it to include all the info I need, but it takes a while. Also the times are in decimals but I use a calculator to find out the minutes. I need the code to find the above values and convert them from decimals to hrs and mins.
22 freelancere byder i gennemsnit $48 for dette job
Hi , I can help with your assignment. I have closed more than 150 excel projects. Please provide the excel sheet for having a better understanding of work. Regards Sawan
Hi: I have done multiple macro projects. Please check my profile to confirm. I would be happy to discuss your requirements in details. Please connect with me.