Forum Discussion
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
| 0,2 | 0:12 |
| 1,25 | 1:15 |
| 8,5 | 8:30 |
| 23,5 | 23:30 |
| 49,5 | 49:30 |
| 123,5 | 123:30 |
| 49,6 | 0:49 |
| 155,9 | 2:35 |
If you want to correct your formula:
=ARVO(KOKONAISLUKU(A8)&":"&PYÖRISTÄ(JAKOJ(A8;1)*60;0)&":00")
When I try to translate the formula, most functions are recognized but JAKOJ is unknown. Do you know what it is in English?
Thank you. I see now that there is a misplaced ' before C26, this threw off the translation.
Can you explain the problem more clearly?
