Forum Discussion

Hannu_Siirala's avatar
Hannu_Siirala
Copper Contributor
Aug 08, 2022

Time calculation

Hi, I tried to calculate time but problem is: shell calculate only 15 min steps times.   ex.  =ARVO(KOKONAISLUKU(SUMMA('C26:W26))&":"&JAKOJ(SUMMA(C26:W26);1)*60)   Shell type is own: [h]:mm   ...
  • HansVogelaar's avatar
    HansVogelaar
    Aug 08, 2022

    Hannu_Siirala 

    If you want to correct your formula:

    =ARVO(KOKONAISLUKU(A8)&":"&PYÖRISTÄ(JAKOJ(A8;1)*60;0)&":00")

Resources