I need to create a timer that can be stopped and continue counting time.
I found a solution, not quite what I need, but so far there is no other solution I'll use.
"Date + time"1 - "Date + time" 2
But the problem is that it shows day-hour-minute-second-millisecond. I've had enough Day-hours-minute
You could try something like:
let d := 24 * 60 * 60 * 1000; let h := 60 * 60 * 1000; let s := 60 * 1000; let src := number('Date + Time 1' - 'Date + Time2'); let days := floor(src / d); let hour := floor((src - days * d) / h); let min := round((src - days * d - hour * h) / s); days + " Days, " + hour + " Hour(s), " + min + " minutes"
- Status Answered
- 3 mths agoLast active