Aug 07 2022 11:17 PM
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 |
Aug 08 2022 12:00 AM
When I try to translate the formula, most functions are recognized but JAKOJ is unknown. Do you know what it is in English?
Aug 08 2022 02:05 AM
Thank you. I see now that there is a misplaced ' before C26, this threw off the translation.
Can you explain the problem more clearly?
Aug 08 2022 03:03 AM
Aug 08 2022 03:43 AM
You could use =A8/24 and format the cell with the formula as [h]:mm
Aug 08 2022 03:48 AM
SolutionIf you want to correct your formula:
=ARVO(KOKONAISLUKU(A8)&":"&PYÖRISTÄ(JAKOJ(A8;1)*60;0)&":00")
Aug 08 2022 03:48 AM
SolutionIf you want to correct your formula:
=ARVO(KOKONAISLUKU(A8)&":"&PYÖRISTÄ(JAKOJ(A8;1)*60;0)&":00")