Forum Discussion
ConcreteKid
May 09, 2024Copper Contributor
Only including cells containing certain words / numbers in formula?
I have a new job as a sepsis specialist nurse. At the end of the month, using all the data inputted throughout the month, I have to work out how many high risk patients received IV antibiotics withi...
ConcreteKid
May 09, 2024Copper Contributor
If I needed to work out the percentage under 90 minutes, what would I change in the formula?
HansVogelaar
May 09, 2024MVP
90 minutes is 1 hour and 30 minutes, so change TIME(1, 0, 0) to TIME(1, 30, 0)