G Guest May 17, 2005 #1 I need to add a lot of logged hours. What is the best way to do it? I then need to subtract yearly hours to see if they went up or down
I need to add a lot of logged hours. What is the best way to do it? I then need to subtract yearly hours to see if they went up or down
B Bob Phillips May 17, 2005 #2 =A1+A2+A3 etc make sure you format the result as [hh]:mm subtract uearly hours =(H1*24)-yearly_hours and format as General -- HTH RP (remove nothere from the email address if mailing direct)
=A1+A2+A3 etc make sure you format the result as [hh]:mm subtract uearly hours =(H1*24)-yearly_hours and format as General -- HTH RP (remove nothere from the email address if mailing direct)