I have project for pigeon racing. One function is to calculate the flying time used by the pigeon from release to home.
Release time, usually in the morning, is different every time. And sometimes we have races where some pigeons come home the day after or 3rd day. The pigeon cannot fly in the night when it is dark, so we have given times when the counting of flying time is halted. The counted flying time is stopped at a given time in the evening and continues at a given time in the morning when it is light again. This period we call night time.
I have searched my Excel 2010 all over, but cannot find anything that I can use. So I guess I need a macro. As I am still a beginner in making macros, I ask for help in this. But if it is a function/formula in Excel that I didn’t find and can be used, I would appreciate help with this also.
I have in my spreadsheet already in cells (among other things):
D3: function NOW ()
D7: Calendar where I can pick release date
E7: release time, written manually
E8: Distance in km (123,456)
C9: night time start, written manually (so far)
E9: night time ending, written manually (so far)
F12: formula showing actual time(not flying time) since release
D12: counting of days between release day and actual day (day today), using INT(D3)-D7
I3: Macro clock showing actual time (NOT AM-PM) (macro delivering only decimals)
The result of this calculation is to be shown in cell E11. I want it to show the flying time “live” and counting before and after night time, but standing still during night time.
attachments: Clip of spreadsheet and Macro clock
Bookmarks