Go to Settings -> Setup Prayer Timings-> Import Prayer Times via Spreadsheet.

 


Image Placeholder


Image Placeholder


  • Click on Import Guide to download template file.

Image Placeholder
Image Placeholder


Fill template with Prayer times

·        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:



When 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 Choose File
     button



    Image Placeholder


    Click Import button


    NOTE: You can also view the selected prayer timings by selecting the date range with a compact view. 


    Image Placeholder