First post here, am impressed with Ricks help in mr excel, so decided to join here.

Would like this in vba if possible please
Ok here are my cells in E:E starting E2

2015-10-29T02:45:00+00:00
2015-10-29T03:20:00+00:00
2015-10-29T03:05:00+00:00
2015-10-29T04:52:00+00:00
2015-10-29T04:03:00+00:00
2015-10-29T04:40:00+00:00
2015-10-29T06:00:00+00:00


Need to extract to F2 down, Time formatted as HH:MM EG: 02:45 PM

any help will be appreciated
Graham