I’m creating a spreadsheet sleep journal for my doctor and every time I try to put in times, it tries to auto correct to dates. I’ve tried changing the time settings in styles but it doesn’t stick. What am I doing wrong?
Check date-acceptance patterns. Usually you have different separators like / for date and : for time or . In date : in time. This depends on language settings.
.
Internally both strings are converted to a number. Time is a fraction of a date (6 AM = 0.25 etc) Date is a number of days since end of 1899. Add both and you have a time in a certain day