Sheets: Better support for manually inputting durations
I really like that Proton Sheets properly supports time-only data and durations. However, manually inputting a duration is a bit of a hassle, as the underlying data seems to be in fractions of a day: If I want my duration cell to display e.g. "8:00:00", I have to input 0.33333 or =8/24. It would be nice if Sheets recognized some common time durations, so that e.g. 8h, 8h30, 8.5h or 8:30 is converted to the proper duration value.
1
vote