0

Time Timer

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

3 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 1 yr ago
    • Reported - view

    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"
      • iliper LTD
      • iliper_LTD
      • 1 yr ago
      • Reported - view

       Thanks, excellent
      Can days be converted to hours too? 26 hours and 20 minutes or if days is 0, don't show it

      • Ninox partner
      • RoSoft_Steven.1
      • 1 yr ago
      • Reported - view

       sure, just change the last line to: (to hide if the days are 0)

      if days > 0 then days + " Days, " end + hour + " Hour(s), " + min + " minutes"
Login to reply

Content aside

Categories

View all topics
  • Status Answered
  • 1 yr agoLast active
  • 3Replies
  • 77Views
  • 2 Following