Split range of times into time intervals

[Havreliuc]

Hello everyone and happy new year!

I need a bit of help with some times. I have a column with different times (hh:mm format) and i need to split them in 3 new columns with different range, column A (00:00>00:59),column B (01:00>02:59) and column C above 03:00. Note that in the column i also have empty spaces.

I made a small example in the sheet attached.

Can someone help, please?

Thank you

[Glenn Kennedy]

Use three formula, variants of this one:

=IF(AND(B2>=0,B2<1/24),B2,"")

you may need to use ; instead of ,

[Glenn Kennedy]

Hi. Forum Rule 1 is very short. It states: "Title must briefly summarize your request."

A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.

Since you are a new user of this site, on this occasion, I have changed it for you.

However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.

*Other search engines are available!!!

Regards,

Glenn.

[Havreliuc]

Thank you Glenn!

When i don't know what formula to apply, i have problems summarizing the title, sorry. I'll do my best in the future.

Have a nice day.

[Glenn Kennedy]

It's not easy... I agree!!

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It would also be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.