Go to Settings > Setup Prayer Timings > Change Source> Import via Excel.
Click on Download Template to download the template file. This file should be filled with the required prayer timings and then uploaded in the system.
Fill template with Prayer Timings:
Fill the time in 24HRS format (e.g. 1:30 PM should be entered as 13:30) except Maghrib columns because they are free form text and whatever you write, it will display as is for Maghrib timings.
- Do not delete any row or column or change any heading.
- Do not insert any formulas in the file
Note: If you have to copy paste the times from a different sheet make sure while pasting to template, use Paste Special -> Values (This way, if you have any formula or special formatting it will not impact template)
Upload file by clicking on Browse Files button > Click Update button
A green color prompt will Appear “Records Imported Successfully”.
All
Prayer Timings will be displayed upon clicking “View All Prayer Times” button
You can also EDIT and SAVE the Adhan
and Iqamah timings manually for one day from the same screen.
