Hi there,
I a trying to add some time totals using sumif. The formula is as follows:
=SUMIFS('SheetA'!$H$14:$H$143,'Sheet B'!H$14:H$143,"TRUE")
Sheet A's reference is looking at a column that works out the time difference between two columns. The two columns are set as hh:mm. The time...