Hi All
Using excel 2007 column B contains dates in 24 hour format,I would like to change these times to 12 hour format as shown in column A.
Thanks for any help given.
A B
05:50 17:50
06:20 18:20
06:50 18:50
07:20 19:20
07:50 19:50
08:20 20:20
08:50 20:50
09:20 21:20
01:55 13:55
02:30 14:30
03:05 15:05
03:45 15:45
04:25 16:25
05:05 17:05
05:40 17:40
Bookmarks