nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

714151_en-US

liliconcom

Counting values in column

Hi,

I need help using the Count function. I think I may be able to us this for what I need but not sure how. I've attached a sample data table. For the Column "day night 5 min intervals" I want to use a formula to count the number of values of the same number in the column "Counter" (This is to help me calculate the length of day and length of night)

I created the day or night columns and the counter columns to get me to my final result in Day/night hours. Unless there is an easier way to do this?

And follow up question: Is there an easy way to turn a duration (number of hours in decimal format) into hr: min. For example - 13.5 hrs becomes 13:30.