Form Date Time not working in Sheets (Zoho Form with Zoho Sheets Integration)

Form Date Time not working in Sheets (Zoho Form with Zoho Sheets Integration)

hi,

I've been using the 'Added Time' from a Form to Sheets since April. It worked perfectly, but for some reason since 20 December Sheets will no longer recognise the 'Added Time' as a Date Time cell. The cell format is correct, and the Form & Sheets date/time/region are set as UK GMT.  Please advise how to correct this issue and the reason it suddenly started?

Please see in column A the Added Time is OK for the first row, the date/time is in the right of the column and in column B I am able to do a simple date calculation.
(I have hidden many rows between 22 Apr > 20 Dec and the date time worked fine for them.)
For the next row which has date stamp starting 20-Dec, the field aligns left in the column and in column B it will not do a simple date calculation.


The cell format in column A is the same. Please see cell format of A2 below:


The cell format for 20 Dec has the same setting, but note the Preview shows the current date/time as it doesn't recognise the field as a Date Time field.


I have tried many different date/time settings but none of them correct the date time, which remains from 20 Dec on the left of the column.

Since the form settings appear to be correct I'm not sure what to try - please advise?

Thank you
    Zoho Desk Resources

    • Desk Community Learning Series


    • Digest


    • Functions


    • Meetups


    • Kbase


    • Resources


    • Glossary


    • Desk Marketplace


    • MVP Corner


    • Word of the Day


      • Sticky Posts

      • Moving out announcement - Zoho Sheet!

        Greetings!   As a way to better interact with our users, the Zoho Sheet team is moving our forum out of the Zoho Docs community and in to its own separate space. This is the first step in creating a stand-alone community for Zoho Sheet. ​ This will help us fit all your queries and posts about Sheet into one community and ensure you receive our forum announcements in a timely fashion. There are also plans down the line to kick-start sessions like "Ask the Experts" and "Tips and Tricks," so make sure to

      Zoho CRM Plus Resources

        Zoho Books Resources


          Zoho Subscriptions Resources

            Zoho Projects Resources


              Zoho Sprints Resources


                Zoho Orchestly Resources


                  Zoho Creator Resources


                    Zoho WorkDrive Resources



                      Zoho Campaigns Resources

                        Zoho CRM Resources

                        • CRM Community Learning Series

                          CRM Community Learning Series


                        • Tips

                          Tips

                        • Functions

                          Functions

                        • Meetups

                          Meetups

                        • Kbase

                          Kbase

                        • Resources

                          Resources

                        • Digest

                          Digest

                        • CRM Marketplace

                          CRM Marketplace

                        • MVP Corner

                          MVP Corner




                          Zoho Writer Writer

                          Get Started. Write Away!

                          Writer is a powerful online word processor, designed for collaborative work.

                            Zoho CRM コンテンツ




                              ご検討中の方