Appointment Times to be grouped

Hi All

Can someone please help, I have a list of client appointments that I'm required to group (see below),

( 01.00Hrs – 07.00 Hrs) ( 07.00Hrs – 12.00hrs)(12.00hrs – 17.00Hrs)( 17.00hrs- 1.00Hrs )

I have adapted one of my other formulas to capture this and sort, however I keep getting an error, the formula is;

=IF(D2<>"",IF(AND(D2>=01:01:00,D2<=07:00:00),"01:01-07:00",IF(AND(D2>=07:01:00,D2<=12:00:00),"07:01-12:00",IF(AND(D2>=12:01:00,D2<=17:00:00),"12:01-17:00",IF(AND(D2>=17:01:00,D2<=01:00:00),"17:01-01:00")))),"")

Your help is very much appreciated.

Clash

Hi Clash,

Please post a sample workbook.. thanks.



Regards,
DILIPandey
<click on below * if this helps>

Hi Clash,

Please post a sample workbook.. thanks.



Regards,
DILIPandey
<click on below * if this helps>

We need to include following as a column :-
( 01.00Hrs – 07.00 Hrs) ( 07.00Hrs – 12.00hrs)(12.00hrs – 17.00Hrs)( 17.00hrs- 1.00Hrs )
and then using formulas we can obtain Groupings.. let me know if this suits you.



Regards,
DILIPandey
<click on below * if this helps>

Hi Clash,

You are typing formula reference in D2 by sitting in D2 only.. that wont work.. also for time, it would be better for you to type them some where in cell and then use those reference in your formula rather than typing them manually.


Regards,
DILIPandey
<click on below * if this helps>

Hi again,

I've done as i've shown and still I'm still getting the error, thanks for you help anyway, but I think I'll have to call it a day on this.

Many thanks again.

PS. I've solved using a range and linking to that, once again thanks for looking.