Date-time data entry in local time for daylight savings time "turn back" transition period

by Coxy   Last Updated April 16, 2019 06:16 AM

I have an application in which users can enter tabular data such as:

start               | value
------------------- | -----
12:30:00 27/10/2019 | 0
01:30:00 27/10/2019 | 1
02:30:00 27/10/2019 | 2

It turns out that 27/10/2019 02:00:00 (date given in UK format, so 10/27/2019 for Americans) is the "roll back" daylight savings instant for the UK. That is, at 2am, clocks are rolled back to 1am. That is, all times between 1am and 2am occur twice, and there is effectively a 25 hour day. As such, the second row in the table above is an ambiguous time. Does the user mean the first occurrence of this time, or the second?

What is a good way to provide UX around this (This is an html/js web application so there are quite a few options graphically)? Adding another column to the table seems extremely verbose just for this edge case. Displaying date-times in UTC is not an option either, as this would make the day-to-day usage of the application quite difficult for users.

Tags : tables dates time

Related Questions

Updated December 08, 2016 08:06 AM

Updated July 24, 2015 13:07 PM

Updated May 30, 2016 08:06 AM

Updated March 17, 2017 03:16 AM

Updated October 25, 2018 02:16 AM