I need some advice please:
I am supplied with a schedule (generated from a server) which lists times in the following format as an example:
Given Text Time
2330
5
40
115
150
220
2310
2340
Not very neat & tidy! I have a formula that works for every time, except for the hour past midnight. =--(LEFT(C2,LEN(C2)-2)&":"&RIGHT(C2,2)) (thanks to this forum)
Times such as '5' and '40' result in a #Value! error.
I also need to sort the times past midnight as in.... 23:30 would come before 00:05
Any help would be greatly appreciated.
Bookmarks