Cross sheet reference function
 

Hey,

I'm a newbie to use Excel. I need to come up with a workbook has 2 spread
sheets in it.
The first sheet hold the project name, Time I spent on it, Date etc. I have
several projects in one day. In the second spread sheet I need to know total
hour I spent on the projects. I do not want to hand input the hours. Is there
a formula or function I can use so the hour information in the 2nd
spreedsheet could be updated automaticallly according to the data I entered
in the 1st sheet?

Thanks in advance!
Rocky

Cross sheet reference function
 

If u have Project-names i Sheet1 column A
And Hour in Sheet1 column B (put in as times fx. 2:15)

in Sheet2 A2 copy down to row 1000

=IF(COUNTIF(Sheet1!A2:$A$1000,Sheet1!A2)=1,Sheet1! A2,"")
-------------------------------------------------------------------------------
if u have to edit this formula, do it before copying down !
in Sheet2 B2 copy down to row 1000,- while still selected CTRL+SHIFT+ENTER

=IF(ISERR(SMALL(IF(A2:A1000<"",ROW(INDIRECT("1:"& ROWS(A2:A1000)))),ROW(INDIRECT("1:"&ROWS(A2:A1000) )))),"",INDEX(A2:A1000,SMALL(IF(A2:A1000<"",ROW(I NDIRECT("1:"&ROWS(A2:A1000)))),ROW(INDIRECT("1:"&R OWS(A2:A1000))))))
------------------------------------------------------------------------------
in Sheet2 C2 copy down to row 1000

=IF(B2="","",COUNTIF(Sheet1!A2:A1000,Sheet2!B2,She et1!B2:B37))
Custumformat [h]:mm