How to make a good continuous graph in google sheets for clock values around 00:00 at night
I have a dataset similar to below in google sheets that I want to plot in a line chart with dates on the x-axis and time on the y-axis.
Date Time 2023-01-01 23:46 2023-01-02 00:32 2023-01-03 00:16 2023-01-04 22:37 2023-01-05 23:59
As you can see the times varies around midnight (00:00) which does not go well with a ordinary line chart since the 00:16 will be in the bottom of the chart and 23:59 will be at the top of the chart even though its only 17 minutes apart. How can I correct this to make a "better" and smoother graph?
I have managed to make it more smooth by either subtracting or adding 12h (23:59 becomes 11:59 and 00:16 becomes 12:16 for the actual y-values) so that the graph instead "oscillates" around noon instead of midnight, then the graphical representation is correct but the actual values on the y-axis is still wrong. How can I solve this problem to make a more smooth graph and correct time values on the y-axis?
A possible workaround is to add 1 if the time is after midnight (i.e. before 12 noon the next day, which is represented as 0.5 days):
=B2+(B2<0.5)
- List of Time Zones in Java
- How to convert a String to a Date using SimpleDateFormat?
- When to use datetime.utcnow() or datetime.now(tz=pytz.utc).replace(tzinfo=None)
- Select rows for a specific date using TIMESTAMP datatype
- Insert appropriate number of rows into data frame based on date differences
- Java 8 DateTimeFormatter to ignore millisecond and zone
- Incorrect datetime conversion from America/New_York time to UTC and back to America/New_York
- matplotlib event.xdata out of timeries range
- Convert Zulu time zone to a specific format with javascript?
- Running python script inside Docker container wrong timezone
- How to get current isoformat datetime string including the default timezone?
- How can I "pretty print" a Duration in Java?
- How to group a datetime column by year?
- How to get the day of the year [1-365|366] with Luxon?
- ValueError: time data '24:00' does not match format '%H:%M'
- DateTime.ToString() display meridiem as "A.M." or "P.M."
- Getting the first and last day of a month, using a given DateTime object
- How to get the current time in seconds since the epoch, in Bash on Linux?
- Flutter : How to set the hours, minutes and seconds to 0 from today's date irrespective of the time?
- Why Joda DateTime gives different result than Java Date?
- php convert datetime to UTC
- Getting the TimeZoneIDs for a Time Zone
- What's the best way to get the number of days in a month using the java.time API?
- checking java date with postgresql timestamp without timezone
- What's the difference between Instant and LocalDateTime?
- How can I convert a Unix timestamp to DateTime and vice versa?
- DateTime vs DateTimeOffset
- How to determine upcoming months relative to a given month in any calendar?
- Convert ISO 8601 string in UTC to local time - JodaTime is adding the opposite of local time zone
- Count the number of inclusive dates covered by a date period