Excel Formula Time

smartguy

Well-known Member
Joined
Jul 14, 2009
Messages
775
Hello all,

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

Excel Workbook
FG
1TimeTime Slot
212:35:00 PM
312:43:00 PM
412:47:00 PM
512:23:00 AM
612:31:00 PM
71:43:00 PM
82:19:00 PM
92: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...
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

pjmorris

Well-known Member
Joined
Aug 2, 2012
Messages
1,972
Office Version
  1. 2016
Platform
  1. Windows
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

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,827
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
Possibly

Excel Workbook
FG
1TimeTime Slot
212:35:00 PM12 PM - 01 PM
312:43:00 PM12 PM - 01 PM
412:47:00 PM12 PM - 01 PM
512:23:00 AM12 AM - 01 AM
612:31:00 PM12 PM - 01 PM
71:43:00 PM01 PM - 02 PM
82:19:00 PM02 PM - 03 PM
92:35:00 PM02 PM - 03 PM
Sheet3
 
Last edited:

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,827
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
Sorry put in a - rather than"to".

Excel Workbook
FG
1TimeTime Slot
212:35:00 PM12 PM to 01 PM
312:43:00 PM12 PM to 01 PM
412:47:00 PM12 PM to 01 PM
512:23:00 AM12 AM to 01 AM
612:31:00 PM12 PM to 01 PM
71:43:00 PM01 PM to 02 PM
82:19:00 PM02 PM to 03 PM
92:35:00 PM02 PM to 03 PM
Sheet3
 
Last edited:

pjmorris

Well-known Member
Joined
Aug 2, 2012
Messages
1,972
Office Version
  1. 2016
Platform
  1. Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,328
Members
414,054
Latest member
Sameer50

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top