Title: Difficulty Matching Plugin’s Data Format Requirements
Last modified: April 26, 2022

---

# Difficulty Matching Plugin’s Data Format Requirements

 *  [keyboardzap123](https://wordpress.org/support/users/keyboardzap123/)
 * (@keyboardzap123)
 * [4 years, 1 month ago](https://wordpress.org/support/topic/difficulty-matching-plugins-data-format-requirements/)
 * 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](https://wordpress.org/support/users/mmrs151/)
 * (@mmrs151)
 * [4 years, 1 month ago](https://wordpress.org/support/topic/difficulty-matching-plugins-data-format-requirements/#post-15591733)
 * 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.

 * ![](https://ps.w.org/daily-prayer-time-for-mosques/assets/icon-128x128.png?rev
   =1215663)
 * [Daily Prayer Time](https://wordpress.org/plugins/daily-prayer-time-for-mosques/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/daily-prayer-time-for-mosques/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/daily-prayer-time-for-mosques/)
 * [Active Topics](https://wordpress.org/support/plugin/daily-prayer-time-for-mosques/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/daily-prayer-time-for-mosques/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/daily-prayer-time-for-mosques/reviews/)

## Tags

 * [Excel](https://wordpress.org/support/topic-tag/excel/)

 * 1 reply
 * 2 participants
 * Last reply from: [mmrs151](https://wordpress.org/support/users/mmrs151/)
 * Last activity: [4 years, 1 month ago](https://wordpress.org/support/topic/difficulty-matching-plugins-data-format-requirements/#post-15591733)
 * Status: not resolved