ok, and here is the spreadsheet i have been working off.

its a bit of a whopper, so may take a while to download.

you will need to hit F9 to recalculate after making adjustments.


the yellow cells are ones you can alter, and SHOULD alter the results.

please enter them in the formats that they are already in. eg type the day in full, and the times are 500, 1800, 2300 etc.

please also note, that i think the times on my data are GMT + 5 for some reason ( could someone verify this please??) so 500 is actually 0000 GMT , 2300 is actually 1800 GMT etc.


hope this helps,

FC