Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 13 Apr 2015 13:42:30 +0200applying function in Calchttps://ask.libreoffice.org/en/question/49216/applying-function-in-calc/Hi all,
How to make function that calculate time difference from col A and B and automatically the result is shown in col C
function I used is: =(Bn<An)+Bn-An, where n is number of row.
The problem is, that function must be applied manually each time I want the result / time difference /Mon, 13 Apr 2015 13:30:21 +0200https://ask.libreoffice.org/en/question/49216/applying-function-in-calc/Answer by karolus for <p>Hi all,</p>
<p>How to make function that calculate time difference from col A and B and automatically the result is shown in col C
function I used is: =(Bn<an)+bn-an, where="" n="" is="" number="" of="" row.="" the="" problem="" is,="" that="" function="" must="" be="" applied="" manually="" each="" time="" i="" want="" the="" result="" time="" difference="" <="" p="">
</p> https://ask.libreoffice.org/en/question/49216/applying-function-in-calc/?answer=49218#post-id-49218Start in C1 with:
=B1-A1+(B1<A1)
and simply pull down.
Mon, 13 Apr 2015 13:42:30 +0200https://ask.libreoffice.org/en/question/49216/applying-function-in-calc/?answer=49218#post-id-49218