close

I am setting up an excel spreadsheet to use for attendance tracking. What I
need to write a formula that will caculate every X to equal 2 hours and then
total how many hours that person was in class.

Can someone help me on how to do this?

Thanks,


Perhaps

=COUNTIF(A1:A10,quot;Xquot;)*2

adjust range as necessary--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=520865

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()

E-mail轉寄