excel, numbers, etc

How To Add Time In Excel Or Numbers | Jonathan Laliberte

The reason for this is that Excel (and Numbers, and.. most likely any other spreadsheet software out there) keeps track of dates, not time – so if you have a date of 6/19/2009, and in the next cell you want 6/20/2009 – you add 1. Well, there are 1440 minutes in a day, so you simply have to add a fraction of a day equal to the amount of time you want to add. So 15/1440 = 0.0104166667 days.

=VLOOKUP(search-for,columns-range,return-column,close-match)

计算其 A 列与当前表 A2 值相同 TABLE1 的行数:

=COUNTIF(table1 :: $A,A2)

计算其 A 列与当前表 A2 值相同, 且其 F 列值为忽略的 TABLE1 的行数:

=COUNTIFS(table1::A,A2,table1::Task,"=忽略")

=SUMIFS(syslog 统计 :: 总数,syslog 统计 :: $A,">=07/26/13",syslog 统计 :: $A,"<=08/01/13")