Google map, 'openingHours' cells time format

[goldy]

Would it be possible to have the option to output the ‘openingHours’ cells time format in military time format instead, like this for example:
[“Mo 09:00-17:00,18:00-23:59”,“Tu 00:00-08:00,09:00-17:00”],[“UTC”:“-5:00”]

Thanks!

[Tim]

Ill need to see, the data is pulled as text and might need some parsing in order to convert it.

How are you using the data? Maybe the program has some form of date parsing and formatting?

[goldy]

I’m using it with the wp plugin Geodirectory, if I want to import in bulk business hours on csv file it only accept this time format.
Thanks

[Tim]

Ok undertstood,

[Tim]

Had a close look at this and its much more complex than it seems.

1. Google maps reports more than just dates (also includes warnings for holidays) eg
   

   

2. Google sometimes doesn’t report a closing time date ie 24 hrs
   

   

3. Times are actually reported in 24hr time depending on region
   

   

I only tested this region, but its possible in another region date and times are reported differently again.

This makes parsing the info difficult as its not reported in any standard manner.

[goldy]

I see, thanks for looking into it.
In the end I managed to format the time with Chatgpt, it takes a bit more time but it does the job.

[Tim]

Yep an AI model here might be better as it can handle multiple different or unknown formats.

Its possible to do this all in SCM, just create CSV, then send CSV to the AI CSV tool and create a new column using AI prompt.