Get difference between two times

Jsword · Newbie Joined: 08 Oct 2011 Posts: 4

hi there
i have two columns A,B of type time for example: 10:12 AM
and i have column C and i want to get the difference between A,B in it
as hours:minutes, please describe to me how to do that
thanks in advance.

Villeroy · Posted: Sat Oct 08, 2011 3:12 pm Post subject:

=B1-A1
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

Jsword · Newbie Joined: 08 Oct 2011 Posts: 4

where or how to add this: by double clicking on a cell and add above formula
or insert it as new function or what, please describe.

philb1 · Posted: Sun Oct 09, 2011 6:29 pm Post subject:

If you have a time in cell A1 and a time in cell B1, type =B1-A1 into cell C1, press enter & it will give you the time difference in hours, minutes & seconds
Change the times in A1 & B1 as you like.

Jsword · Newbie Joined: 08 Oct 2011 Posts: 4

do i have to do that for each field ?
what if i wanted to make this formula for all cells in the column
i want to insert a formula for the whole column, so that each time two times are entered in any cell, automatically the third column will calculate the difference, got me ?

Jsword · Newbie Joined: 08 Oct 2011 Posts: 4

well. i managed to do it as follows:

in one of the cells in c i used the formula: =(C2<B2)+C2-B2
then i dragged the thin border of this cell and expanded it to other cells of this column, and then the formula is applied to other cells in the column.