Excel Formula Time

[smartguy]

Hello all,

Good day. I have excel file in the below format.

Excel Workbook
	F	G
1	Time	Time Slot
2	12:35:00 PM
3	12:43:00 PM
4	12:47:00 PM
5	12:23:00 AM
6	12:31:00 PM
7	1:43:00 PM
8	2:19:00 PM
9	2:35:00 PM
November'14

I Need Time Slot Like 12.00 AM to 1.00 AM , 1.00 Am to 2.00 AM , 2.00 AM to 3.00 AM like that...

 

[pjmorris]

Use this:

=CHOOSE(HOUR(F2)+1,"First","Second", "Third", "Fourth", "Fifth", "Sixth", "Seventh", "Eight", "Nineth", "Tenth", "Eleventh", "Twelth", "Thirteenth", "Fourteenth", "etc")

You'll need to replace the first, second, third etc with whatever text you want to display.

Regards

 

[MARK858]

Possibly

Excel Workbook
	F	G
1	Time	Time Slot
2	12:35:00 PM	12 PM - 01 PM
3	12:43:00 PM	12 PM - 01 PM
4	12:47:00 PM	12 PM - 01 PM
5	12:23:00 AM	12 AM - 01 AM
6	12:31:00 PM	12 PM - 01 PM
7	1:43:00 PM	01 PM - 02 PM
8	2:19:00 PM	02 PM - 03 PM
9	2:35:00 PM	02 PM - 03 PM
Sheet3

 

[MARK858]

Sorry put in a - rather than"to".

Excel Workbook
	F	G
1	Time	Time Slot
2	12:35:00 PM	12 PM to 01 PM
3	12:43:00 PM	12 PM to 01 PM
4	12:47:00 PM	12 PM to 01 PM
5	12:23:00 AM	12 AM to 01 AM
6	12:31:00 PM	12 PM to 01 PM
7	1:43:00 PM	01 PM to 02 PM
8	2:19:00 PM	02 PM to 03 PM
9	2:35:00 PM	02 PM to 03 PM
Sheet3

 

[pjmorris]

Morning Smartguy,

Any chance of feedback - you've different approaches from two of us and gaining feedback is the only way we know whether our efforts have been either understood or appreciated.

Regards