Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

How can I simplify this formula and also create a loop?

Copper Contributor

This is a simple If formula:




cell G26 is an input cell where the user enters number of PTO days in a given month

the formula should return the number of working hours (8) for the given value where 1 day = 8hrs, 2 days = 16 days, etc.

I used the above formula but I am sure there is an easier way

1 Reply

@GabeR918 Why not just: