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?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.