I want to write a function in Excel. I have prepared a Gantt chart with dates as a row header. I have to fill in the task's start date and end date and each task has a particular duration. I wanted to split each day into 3 slots(8 hours each). For example, if a task has a start date of 09-06-2023 and it will take 32 hours to complete the task, then it should fill the cell under 09-06-2023 completely and the cell under 10-06-2023 partially (1/3rd part of a cell) also ignore weekends.
I wanted to write a function because I have linked my Excel with power automate and I see power automate doesn't support .xlsm format. I have attached a pic for your reference.
Please help me to write a function in conditional formatting.
Thank you.
Hi Leela,
Welcome to our forum. Your question is difficult to answer because the image you have shared is too small and those helping would have to recreate your spreadsheet to help you.
Please upload an example file that mocks up the scenario you're referring to and your desired result, and share it here so someone can help you.
Mynda
