Spreadsheet: 103635d1301384189-financial-calendar-formula-financial-calendar-formula
Sheet: Sheet2

Date | Week commencing | Time | Week No. | Day No. | HH Slot No.
2011-09-20 00:00:00 | 2011-09-19 00:00:00 | 18:00:00 | 38 | 2 | 37
2011-09-20 00:00:00 | 2011-09-19 00:00:00 | 18:30:00 | 38 | 2 | 38
2011-09-20 00:00:00 | 2011-09-19 00:00:00 | 19:00:00 | 38 | 2 | 39
2011-09-20 00:00:00 | 2011-09-19 00:00:00 | 19:30:00 | 38 | 2 | 40
2011-09-20 00:00:00 | 2011-09-19 00:00:00 | 20:00:00 | 38 | 2 | 41
2011-09-20 00:00:00 | 2011-09-19 00:00:00 | 20:30:00 | 38 | 2 | 42
2011-09-20 00:00:00 | 2011-09-19 00:00:00 | 21:00:00 | 38 | 2 | 43
2011-09-20 00:00:00 | 2011-09-19 00:00:00 | 21:30:00 | 38 | 2 | 44
2011-09-20 00:00:00 | 2011-09-19 00:00:00 | 22:00:00 | 38 | 2 | 45
2011-09-20 00:00:00 | 2011-09-19 00:00:00 | 22:30:00 | 38 | 2 | 46
2011-09-20 00:00:00 | 2011-09-19 00:00:00 | 23:00:00 | 38 | 2 | 47
2011-09-20 00:00:00 | 2011-09-19 00:00:00 | 23:30:00 | 38 | 2 | 48
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 00:00:00 | 38 | 3 | 1
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 00:30:00 | 38 | 3 | 2
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 01:00:00 | 38 | 3 | 3
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 01:30:00 | 38 | 3 | 4
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 02:00:00 | 38 | 3 | 5
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 02:30:00 | 38 | 3 | 6
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 03:00:00 | 38 | 3 | 7
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 03:30:00 | 38 | 3 | 8
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 04:00:00 | 38 | 3 | 9
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 04:30:00 | 38 | 3 | 10
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 05:00:00 | 38 | 3 | 11
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 05:30:00 | 38 | 3 | 12
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 06:00:00 | 38 | 3 | 13
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 06:30:00 | 38 | 3 | 14
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 07:00:00 | 38 | 3 | 15
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 07:30:00 | 38 | 3 | 16
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 08:00:00 | 38 | 3 | 17
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 08:30:00 | 38 | 3 | 18
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 09:00:00 | 38 | 3 | 19
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 09:30:00 | 38 | 3 | 20
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 10:00:00 | 38 | 3 | 21
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 10:30:00 | 38 | 3 | 22
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 11:00:00 | 38 | 3 | 23
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 11:30:00 | 38 | 3 | 24
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 12:00:00 | 38 | 3 | 25
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 12:30:00 | 38 | 3 | 26
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 13:00:00 | 38 | 3 | 27
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 13:30:00 | 38 | 3 | 28
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 14:00:00 | 38 | 3 | 29
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 14:30:00 | 38 | 3 | 30
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 15:00:00 | 38 | 3 | 31
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 15:30:00 | 38 | 3 | 32
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 16:00:00 | 38 | 3 | 33
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 16:30:00 | 38 | 3 | 34
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 17:00:00 | 38 | 3 | 35
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 17:30:00 | 38 | 3 | 36
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 18:00:00 | 38 | 3 | 37
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 18:30:00 | 38 | 3 | 38
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 19:00:00 | 38 | 3 | 39
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 19:30:00 | 38 | 3 | 40
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 20:00:00 | 38 | 3 | 41
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 20:30:00 | 38 | 3 | 42
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 21:00:00 | 38 | 3 | 43
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 21:30:00 | 38 | 3 | 44
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 22:00:00 | 38 | 3 | 45
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 22:30:00 | 38 | 3 | 46
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 23:00:00 | 38 | 3 | 47
2011-09-21 00:00:00 | 2011-09-19 00:00:00 | 23:30:00 | 38 | 3 | 48
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 00:00:00 | 38 | 4 | 1
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 00:30:00 | 38 | 4 | 2
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 01:00:00 | 38 | 4 | 3
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 01:30:00 | 38 | 4 | 4
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 02:00:00 | 38 | 4 | 5
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 02:30:00 | 38 | 4 | 6
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 03:00:00 | 38 | 4 | 7
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 03:30:00 | 38 | 4 | 8
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 04:00:00 | 38 | 4 | 9
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 04:30:00 | 38 | 4 | 10
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 05:00:00 | 38 | 4 | 11
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 05:30:00 | 38 | 4 | 12
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 06:00:00 | 38 | 4 | 13
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 06:30:00 | 38 | 4 | 14
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 07:00:00 | 38 | 4 | 15
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 07:30:00 | 38 | 4 | 16
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 08:00:00 | 38 | 4 | 17
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 08:30:00 | 38 | 4 | 18
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 09:00:00 | 38 | 4 | 19
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 09:30:00 | 38 | 4 | 20
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 10:00:00 | 38 | 4 | 21
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 10:30:00 | 38 | 4 | 22
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 11:00:00 | 38 | 4 | 23
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 11:30:00 | 38 | 4 | 24
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 12:00:00 | 38 | 4 | 25
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 12:30:00 | 38 | 4 | 26
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 13:00:00 | 38 | 4 | 27
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 13:30:00 | 38 | 4 | 28
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 14:00:00 | 38 | 4 | 29
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 14:30:00 | 38 | 4 | 30
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 15:00:00 | 38 | 4 | 31
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 15:30:00 | 38 | 4 | 32
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 16:00:00 | 38 | 4 | 33
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 16:30:00 | 38 | 4 | 34
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 17:00:00 | 38 | 4 | 35
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 17:30:00 | 38 | 4 | 36
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 18:00:00 | 38 | 4 | 37
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 18:30:00 | 38 | 4 | 38
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 19:00:00 | 38 | 4 | 39
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 19:30:00 | 38 | 4 | 40
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 20:00:00 | 38 | 4 | 41
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 20:30:00 | 38 | 4 | 42
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 21:00:00 | 38 | 4 | 43
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 21:30:00 | 38 | 4 | 44
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 22:00:00 | 38 | 4 | 45
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 22:30:00 | 38 | 4 | 46
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 23:00:00 | 38 | 4 | 47
2011-09-22 00:00:00 | 2011-09-19 00:00:00 | 23:30:00 | 38 | 4 | 48
2011-09-23 00:00:00 | 2011-09-19 00:00:00 | 00:00:00 | 38 | 5 | 1