Citat:
vojvoda1010: treba da u kolonama G i M se zaokruzi na cele minute i sekunde,, ............... to je u sheet RADNO.
Vidi da li ti pomažu ove formule
U G3 postavi ovu formulu i kopiraj do G19
Code:
=VALUE(IFERROR(LEFT(TEXT((($N$2*F3)/$F$19);"00,00");FIND(",";TEXT((($N$2*F3)/$F$19);"00,00"))-1);TEXT((($N$2*F3)/$F$19);"00,00")))+LEFT(IF(VALUE(IFERROR(RIGHT(TEXT((($N$2*F3)/$F$19);"00,00");LEN(TEXT((($N$2*F3)/$F$19);"00,00"))-FIND(",";TEXT((($N$2*F3)/$F$19);"00,00")));""))>60;VALUE(IFERROR(RIGHT(TEXT((($N$2*F3)/$F$19);"00,00");LEN(TEXT((($N$2*F3)/$F$19);"00,00"))-FIND(",";TEXT((($N$2*F3)/$F$19);"00,00")));""))/60;0);1)&","&IF(VALUE(IFERROR(RIGHT(TEXT((($N$2*F3)/$F$19);"00,00");LEN(TEXT((($N$2*F3)/$F$19);"00,00"))-FIND(",";TEXT((($N$2*F3)/$F$19);"00,00")));""))>60;VALUE(IFERROR(RIGHT(TEXT((($N$2*F3)/$F$19);"00,00");LEN(TEXT((($N$2*F3)/$F$19);"00,00"))-FIND(",";TEXT((($N$2*F3)/$F$19);"00,00")));""))-60;VALUE(IFERROR(RIGHT(TEXT((($N$2*F3)/$F$19);"00,00");LEN(TEXT((($N$2*F3)/$F$19);"00,00"))-FIND(",";TEXT((($N$2*F3)/$F$19);"00,00")));"")))
U M3 postavi ovu formulu i kopiraj do M19
Code:
=VALUE(IFERROR(LEFT(TEXT((($N$2*L3)/$L$19);"00,00");FIND(",";TEXT((($N$2*L3)/$L$19);"00,00"))-1);TEXT((($N$2*L3)/$L$19);"00,00")))+LEFT(IF(VALUE(IFERROR(RIGHT(TEXT((($N$2*L3)/$L$19);"00,00");LEN(TEXT((($N$2*L3)/$L$19);"00,00"))-FIND(",";TEXT((($N$2*L3)/$L$19);"00,00")));""))>60;VALUE(IFERROR(RIGHT(TEXT((($N$2*L3)/$L$19);"00,00");LEN(TEXT((($N$2*L3)/$L$19);"00,00"))-FIND(",";TEXT((($N$2*L3)/$L$19);"00,00")));""))/60;0);1)&","&IF(VALUE(IFERROR(RIGHT(TEXT((($N$2*L3)/$L$19);"00,00");LEN(TEXT((($N$2*L3)/$L$19);"00,00"))-FIND(",";TEXT((($N$2*L3)/$L$19);"00,00")));""))>60;VALUE(IFERROR(RIGHT(TEXT((($N$2*L3)/$L$19);"00,00");LEN(TEXT((($N$2*L3)/$L$19);"00,00"))-FIND(",";TEXT((($N$2*L3)/$L$19);"00,00")));""))-60;VALUE(IFERROR(RIGHT(TEXT((($N$2*L3)/$L$19);"00,00");LEN(TEXT((($N$2*L3)/$L$19);"00,00"))-FIND(",";TEXT((($N$2*L3)/$L$19);"00,00")));"")))