Forum Discussion
mollfrog
Apr 04, 2022Copper Contributor
Formula creation help
Hi, Is anyone able to help me create a formula in Excel (Microsoft® Excel® for Microsoft 365 MSO (Version 2201 Build 16.0.14827.20180) 32-bit) that provides the total number of hours to assign t...
Riny_van_Eekelen
Apr 04, 2022Platinum Contributor
mollfrog Perhaps like in the attached file. Rows 5,7 and 9 show the formulae used in the cells on row 3 above each of them. For information only.
- mollfrogApr 04, 2022Copper Contributor
Riny_van_Eekelen Thank you, but I gave you the wrong references, sorry! The table looks like the attached.
The total in V6 should remain blank until anything is entered into V2-5.
- Riny_van_EekelenApr 04, 2022Platinum Contributor
mollfrog You did not attach "the table".
- mollfrogApr 04, 2022Copper Contributor
Riny_van_Eekelen sorry, try now