September 8, 2009

All praise to All, Lord of the Universe. Blessings and peace on prophet Muhammad, his family and all his sahabah.

This is the home of the Solattimes spreadsheet. The spreadsheet is particularly use to tell the solat/salat/payers/namaz times during our air travel. To use this spreadsheet, you will need Microsoft Excel 97 or later.

I may post information about the spreadsheet here. I welcome all sorts of improvement to the spreadsheet. If you have tinkered with the spreadsheet to make it better, you can email me it at solattimes[at] for uploading. I can also be reached at that address for comments.

NOTE : Some have misunderstood that the spreadsheet only works for Doha-Kuala Lumpur. Those are the default locations, but you can actually select many other major cities around the world or enter the latitude and longitude for the solat times calculation.

May Allah give us strength to be steadfast in our prayers, even during our journeys. Amin.

The idea of this tool is to minimise/remove the uncertainty with regards to prayer times during air journey, especially when one traversses several different time zones for some hours. The objective is to make things simpler, not harder, so as we can worship Allah as best and as practically possible. Islam is easy to practice and each practice, if done correctly brings us closer to Allah. If you are confident you can tell the time of fajr, maghrib and isya’ by looking out of your window, then by all means use that. The Prophet (peace and blessings be upon him) said, Remain conscious of Allah, according to the best of your ability.””

Click here to download the latest version of this spreadsheet. The spreadsheet contains two worksheets with further explanations. You can enter the necessary information about your trip before you travel and print out the calculated prayer times and bring it with you in your flight.

All praise to Allah, lord of the universe who have given me the opportunity and strength  to undertake this task and see through it this Ramadhan 1430H. My appreciation goes to individuals who through them, the idea for the need of such a tool came about. My thanks to those who have reviewed this spreadsheet as well. I love you all for the sake of Allah. Jazakumullah khairan kasiran.

What do you think of the tool and have you benefitted from it? I would be happy to hear from you.

May Allah accept all our good deeds and forgive all our sins.




Screenshot of the main input and output worksheets.


The results are also plotted graphically