Not Excel, Helen but something that might be trivial enough for me to have a stab at although my head spins round looking at the numbers and I’m easily confused. I might have got this python attempt wrong, especially with your estimates, and I’m sure it could be done far better. I’ve included 8 as it reads the same both ways but I don’t think there is an instance where it can be reversed:swaps = ['0', '1', '5', 'x', 'x', '2', 'x', 'x', '8', 'x'] x = 0 for hr in range(0, 24): for min in range(0, 60): orig = str(hr).zfill(2) + str(min).zfill(2) rev = "" for i in reversed(range(0, 4)): num = int (orig[i]) if swaps[num] == 'x': rev = "" break else: rev = rev + swaps[num] if len(rev) == 4: revhr = rev[0:2] revmin = rev[2:4] if int (revhr) < 24 and int (revmin) < 60: print (orig[0:2] + ":" + orig[2:4] + " - " + revhr + ":" + revmin) x = x + 1 print(x) 00:00 - 00:00 00:01 - 10:00 00:05 - 20:00 00:10 - 01:00 00:11 - 11:00 00:15 - 21:00 00:20 - 05:00 00:21 - 15:00 00:50 - 02:00 00:51 - 12:00 00:55 - 22:00 01:00 - 00:10 01:01 - 10:10 01:05 - 20:10 01:10 - 01:10 01:11 - 11:10 01:15 - 21:10 01:20 - 05:10 01:21 - 15:10 01:50 - 02:10 01:51 - 12:10 01:55 - 22:10 02:00 - 00:50 02:01 - 10:50 02:05 - 20:50 02:10 - 01:50 02:11 - 11:50 02:15 - 21:50 02:20 - 05:50 02:21 - 15:50 02:50 - 02:50 02:51 - 12:50 02:55 - 22:50 05:00 - 00:20 05:01 - 10:20 05:05 - 20:20 05:10 - 01:20 05:11 - 11:20 05:15 - 21:20 05:20 - 05:20 05:21 - 15:20 05:50 - 02:20 05:51 - 12:20 05:55 - 22:20 10:00 - 00:01 10:01 - 10:01 10:05 - 20:01 10:10 - 01:01 10:11 - 11:01 10:15 - 21:01 10:20 - 05:01 10:21 - 15:01 10:50 - 02:01 10:51 - 12:01 10:55 - 22:01 11:00 - 00:11 11:01 - 10:11 11:05 - 20:11 11:10 - 01:11 11:11 - 11:11 11:15 - 21:11 11:20 - 05:11 11:21 - 15:11 11:50 - 02:11 11:51 - 12:11 11:55 - 22:11 12:00 - 00:51 12:01 - 10:51 12:05 - 20:51 12:10 - 01:51 12:11 - 11:51 12:15 - 21:51 12:20 - 05:51 12:21 - 15:51 12:50 - 02:51 12:51 - 12:51 12:55 - 22:51 15:00 - 00:21 15:01 - 10:21 15:05 - 20:21 15:10 - 01:21 15:11 - 11:21 15:15 - 21:21 15:20 - 05:21 15:21 - 15:21 15:50 - 02:21 15:51 - 12:21 15:55 - 22:21 20:00 - 00:05 20:01 - 10:05 20:05 - 20:05 20:10 - 01:05 20:11 - 11:05 20:15 - 21:05 20:20 - 05:05 20:21 - 15:05 20:50 - 02:05 20:51 - 12:05 20:55 - 22:05 21:00 - 00:15 21:01 - 10:15 21:05 - 20:15 21:10 - 01:15 21:11 - 11:15 21:15 - 21:15 21:20 - 05:15 21:21 - 15:15 21:50 - 02:15 21:51 - 12:15 21:55 - 22:15 22:00 - 00:55 22:01 - 10:55 22:05 - 20:55 22:10 - 01:55 22:11 - 11:55 22:15 - 21:55 22:20 - 05:55 22:21 - 15:55 22:50 - 02:55 22:51 - 12:55 22:55 - 22:55 121
|