SOLVED

# Time calculation

Copper 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

 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
7 Replies

# Re: Time calculation

When I try to translate the formula, most functions are recognized but JAKOJ is unknown. Do you know what it is in English?

# Re: Time calculation

Thank you. I see now that there is a misplaced ' before C26, this threw off the translation.

Can you explain the problem more clearly?

# Re: Time calculation

Wronk 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

# Re: Time calculation

You could use =A8/24 and format the cell with the formula as [h]:mm

best response confirmed by Hannu_Siirala (Copper Contributor)
Solution

# Re: Time calculation

If you want to correct your formula:

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

# Re: Time calculation

THANK

now it works :)
1 best response

Accepted Solutions
best response confirmed by Hannu_Siirala (Copper Contributor)
Solution

# Re: Time calculation

If you want to correct your formula:

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