Adder of Time https://addtime.pistonite.dev
In your Google Sheet, go to Extensions > Apps Script
, and paste
in this script
The following functions are available:
ADDTIME
- Adds a range of cells of time expressionsSUBTIME
- Subtracts 2 cells of time expressionsDIVTIME
- Divides 2 cells of time expressions
Simply copy the TS source to your project
curl https://pistonite.github.io/addtime/dist.ts > somewhere/addtime.ts
Then import and use
import { calc, ratio } from "addtime.ts";