Dear Siegfried! I attach an amended copy of the spreadsheet. Column U should be plainly visible. (It is simply for convenience a copy of Column N). The "working" cells, where I have applied the formulae from Albery Waugh, are L6 to T6. Not elegant, but... es geht gut!
Mit freundlichen Grüßen, Cormac.
Local Apparent Time - Hour Angles.xlsx
Description: MS-Excel 2007 spreadsheet
--------------------------------------------------- https://lists.uni-koeln.de/mailman/listinfo/sundial
