Books

Reading Sessions

lets(  
  readingTime,    
    prop("Reading Sessions")    
    .map(      
      let(        
        duration,           
          current          
          .prop("Duration").split(":")          
          .map(current.toNumber()),
          
        duration.at(0).multiply(3600)        
        .add(duration.at(1).multiply(60))        
        .add(duration.at(2))      
      )    
    )    
  .sum(),
  
  h,     
    readingTime    
    .subtract(readingTime.mod(3600)),  
  m,    
    readingTime.subtract(h)    
    .subtract(readingTime.mod(60)),  
  s, readingTime.subtract(h+m),
  
  h/3600 + ":" + ifs(m/60<10, "0") + m/60 + ":" + ifs(s<10, "0") + s
)

by-nc-sa.eu_-50980.png