Difficulty Matching Plugin’s Data Format Requirements

  • keyboardzap123

    (@keyboardzap123)


    4 years, 1 month ago

    Assalamu’alaikum.

    I am facing difficulties when trying to convert my existing prayer time data in Excel, to match that of the sample spreadsheet. My data currently looks like this:

    6.25 instead of 06:25:00 (which is the plugin’s required format for uploading times). The problem is worse for times like 8.00 because Excel takes it as 8. Also, my prayer times are in the 12-hour format, so there’s no distinction between 6AM and 6PM for example.

    Do you know how I can convert my data to the required format in Excel? I understand that the data format I have now will not work with the plugin. This is something I am finding very challenging.

    I appreciate your help.

    Jazakallah.

Viewing 1 replies (of 1 total)
  • Plugin Author mmrs151

    (@mmrs151)

    4 years, 1 month ago

    Walaikum assalam brother,

    I sometimes face the same problem too, the WordPress system needs it to be inserted in the 24 hours format to make it work with wp time/date settings.
    I normally just do search-replace to make it work.

    Hope that helps.

Viewing 1 replies (of 1 total)

The topic ‘Difficulty Matching Plugin’s Data Format Requirements’ is closed to new replies.

Tags