Ask Your Question
0

applying function in Calc

asked 2015-04-13 13:30:21 +0200

kylie gravatar image

updated 2015-04-13 13:33:29 +0200

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="" <="" p="">

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2015-04-13 13:42:30 +0200

karolus gravatar image

Start in C1 with:

=B1-A1+(B1<A1)

and simply pull down.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-04-13 13:30:21 +0200

Seen: 20 times

Last updated: Apr 13 '15