After some deep research, I've been looking for a way to sum/subtract hours in Quip Spreadsheet (Salesforce subsidiary).
Apparently, time formats such as
25:00:00 are not listed in their menu
Format > Number > More Formats... and I couldn't find any function to help me to convert it directly.
If you sum 15:30 (15 hours and 30 minutes, not the proper hour) and 12:45, it will result 4:15, but the desired result is 28:15 (28 hours and 15 minutes). Am I missing any documentation which can help me or is there any workaround which can solve it? Is this feature included in Quip?