get a count depending on the interval

[Frazzle6]

HI,i have a spreadsheet with time intervals. What i'd like to do is get a count depending on the interval.

I not sure which function to use. I have 0 to 24 hours, 24:01 to 48 hours, and 48:01 to 72 hours and 72:01 hours or more.

The data is on sheet1 column F. The count of the different time intervals goes in to sheet2 B2 for 0 to 24 hours, C2 for 24:01 to 48 hours, D2 for 48:01 to 72 hrs, E2 for over 72 hours.

Thanks

[FDibbins]

Yyou could use the countifs() function for this.

If your hours are aactually hours, remember that hours are actually decimals of 1 (day)

[Frazzle6]

The cells are formatted as [h]:mm, is that what you mean by actually hours?

[FDibbins]

Yes, thats what I meant. If (as a test), you format to general, you will see 12:00 changes to 0.5

[Frazzle6]

Thanks worked a treat.

[FDibbins]

Happy to help and thanks for the feedback