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)
- Convert ticks to unix timestamp
- Find average temperature from a range of datetime for each day in dataframe
- Java get FirstDate and LastDate of following month in MM/dd/yyyy format even if the input is not the first day of the month
- datetime: Round/trim number of digits in microseconds
- Print all day-dates between two dates
- Laravel Carbon (How to calculate exit next payment date)
- how do you sort column names in Date in descending order in pandas
- Why doesn't Dart's DateTime object make use of the less than and greater than operator override methods?
- pandas - change time object to a float?
- DateTime()->sub/add vs DateTime->modify
- MomentJS - Create An ISO 8601 Datetime String In UTC Using Date, Time, And Timezone Variables
- postgresql timestamptz conversion to localtime issue
- How to parse strings to DateTime in C# properly?
- How do I convert milliseconds to minutes and seconds?
- How to extract date from datetime column in polars
- YYYYWW format in SQL Redshift
- Org mode timestamp format when exported
- How to convert time durations to numeric in polars?
- How to get date and time from server and use it as if it was the client's?
- Filter datetime column with object as data type in python
- What was midnight yesterday as an epoch time?
- Kotlin extract time form the date
- Input type DateTime - Value format?
- What is the meaning of: Pandas data cast to numpy dtype of object. Check input data with np.asarray(data) and how can be solved?
- How to validate expiry date on MySQL query
- How to generate a list with every monday, between two dates, and exclude that some a specific list using pandas
- Polars add/substract UTC offset from datetime object
- Pandas how to parse 'datetimeoffset' values from SQL Server that are in binary format
- Simplest PowerShell method to get current time expressed as UTC
- How to check if DST (Daylight Saving Time) is in effect, and if so, the offset?