Forum Discussion
Hannu_Siirala
Aug 08, 2022Copper Contributor
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 ...
- Aug 08, 2022
If you want to correct your formula:
=ARVO(KOKONAISLUKU(A8)&":"&PYÖRISTÄ(JAKOJ(A8;1)*60;0)&":00")
HansVogelaar
Aug 08, 2022MVP
When I try to translate the formula, most functions are recognized but JAKOJ is unknown. Do you know what it is in English?
Hannu_Siirala
Aug 08, 2022Copper Contributor
- HansVogelaarAug 08, 2022MVP
Thank you. I see now that there is a misplaced ' before C26, this threw off the translation.
Can you explain the problem more clearly?
- Hannu_SiiralaAug 08, 2022Copper ContributorWronk calculation, only 0, 0.25, 0.5, 0.75 are correct.
=ARVO(INT(A8)&":"&MOD(A8;1)*60)
Shell type is Custom: [h]:mm
A B
0,20 0:12 correct
1,25 1:15 correct
123,80 2:03
197,00 197:00 Correct
200,10 3:20
271,20 4:31
271,25 271:15 Correct
345,30 5:45- HansVogelaarAug 08, 2022MVP
If you want to correct your formula:
=ARVO(KOKONAISLUKU(A8)&":"&PYÖRISTÄ(JAKOJ(A8;1)*60;0)&":00")