Title: Invalid time format Last modified: August 30, 2016 --- # Invalid time format * Resolved [khaledsaied](https://wordpress.org/support/users/khaledsaied/) * (@khaledsaied) * [10 years, 8 months ago](https://wordpress.org/support/topic/invalid-time-format/) * I have deleted and reinstalled the plugin but now it does not want to accept my .csv file. It says that I must follow 24 hours time format which I do, but still it does not accept the file. * [https://wordpress.org/plugins/daily-prayer-time-for-mosques/](https://wordpress.org/plugins/daily-prayer-time-for-mosques/) Viewing 10 replies - 1 through 10 (of 10 total) * Plugin Author [mmrs151](https://wordpress.org/support/users/mmrs151/) * (@mmrs151) * [10 years, 8 months ago](https://wordpress.org/support/topic/invalid-time-format/#post-6611751) * if it says ‘invalid time format’ it will display the actual row and cell where the invalidity occurs. * Can you please update the ticket with that. * Thread Starter [khaledsaied](https://wordpress.org/support/users/khaledsaied/) * (@khaledsaied) * [10 years, 8 months ago](https://wordpress.org/support/topic/invalid-time-format/#post-6611752) * Assalam ‘alaikom This is what it says: “Invalid Time format, You must follow 24 hours time format, valid time format is HH:MM[24 hours]” * [Joseph Graham](https://wordpress.org/support/users/codifycode/) * (@codifycode) * [10 years, 8 months ago](https://wordpress.org/support/topic/invalid-time-format/#post-6611761) * Same problem me, Brother Please Upload YouTube video tutorial like How to set time WP Blog or how 2 create CSV format file . how 2 upload please i was mail u Screen recorder * Plugin Author [mmrs151](https://wordpress.org/support/users/mmrs151/) * (@mmrs151) * [10 years, 8 months ago](https://wordpress.org/support/topic/invalid-time-format/#post-6611769) * Do you have any empty line between your csv rows? I think that is causing the issue. * I have seen br Khaled’s csv, which has empty lines, which was causing the issue. * [Joseph Graham](https://wordpress.org/support/users/codifycode/) * (@codifycode) * [10 years, 8 months ago](https://wordpress.org/support/topic/invalid-time-format/#post-6611777) * i try your comma separated values (CSV) file i mean your plugin default sample. csv not working me, i don’t why, i think i need more learn CSV [http://www.lynda.com/PHP-tutorials/Exporting-Data-Files-PHP/158375-2.html](http://www.lynda.com/PHP-tutorials/Exporting-Data-Files-PHP/158375-2.html) * Thread Starter [khaledsaied](https://wordpress.org/support/users/khaledsaied/) * (@khaledsaied) * [10 years, 7 months ago](https://wordpress.org/support/topic/invalid-time-format/#post-6611804) * It works perfectly for me now with the latest update. * [JS-28](https://wordpress.org/support/users/js-28/) * (@js-28) * [10 years, 4 months ago](https://wordpress.org/support/topic/invalid-time-format/#post-6611969) * Salam * Firstly, jazakallah for making such a useful plugin. I have been searching for one for a long time to use on our masjid website. * However, after installing the plugin I am having some issues with the CSV file: * 1. I downloaded the default CSV file and uploaded it to test it. It worked fine and it said “365 Rows Inserted successfully”. * 2. I then tried to edit the CSV file starting with the date column. It was in the wrong format (DD-MM-YY) so I changed it to YYYY-MM-DD (but kept same default data) and saved it. However, when I closed the file and reopened it the changes were lost. * 3. I then tried to change only the data for date/time (but kept default formatting) and closed/saved the file. I reopened to check and it was successful. I uploaded this file but got this error: “Invalid Date format, valid date format is YYYY- MM-DD. Found 01-01-16” * Problem: I can upload the default CSV even though the formatting seems to be incorrect. If I edit the data and formatting only the data changes will be successful, but the formatting will be lost. When I upload this file it tells me the format is incorrect. I have tried Excel 2007 and 2016 but same problem. * I would appreciate if you could please assist with this. Wasalam. * Plugin Author [mmrs151](https://wordpress.org/support/users/mmrs151/) * (@mmrs151) * [10 years, 3 months ago](https://wordpress.org/support/topic/invalid-time-format/#post-6611975) * Assalamualaikum brother, * Firstly apology for my long delay. * Can you please download libre office or open office and edit the csv. * Excel is trying to be too clever it seems. * Let me know. * [JS-28](https://wordpress.org/support/users/js-28/) * (@js-28) * [10 years, 3 months ago](https://wordpress.org/support/topic/invalid-time-format/#post-6611976) * Wsalam * Alhamdulillah seems to be working fine now. I downloaded Libre Office and amended the CSV file in line with the format requirements. It uploaded fine. * Jzk for your help. * Plugin Author [mmrs151](https://wordpress.org/support/users/mmrs151/) * (@mmrs151) * [10 years, 3 months ago](https://wordpress.org/support/topic/invalid-time-format/#post-6611977) * Really happy for that. * May I ask you to leave a feedback of your experience of the plugin. * That will help other Masjid to decide easily. * Jazakallah. Viewing 10 replies - 1 through 10 (of 10 total) The topic ‘Invalid time format’ 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/) * 10 replies * 4 participants * Last reply from: [mmrs151](https://wordpress.org/support/users/mmrs151/) * Last activity: [10 years, 3 months ago](https://wordpress.org/support/topic/invalid-time-format/#post-6611977) * Status: resolved