Posted by laura on February 16, 2001 5:30 AM
Okay, I have 2 frustrating problems. Well three. The first is that I seem to have to make a payroll program at my work. I get raw data on how many minutes an employee has worked per hour, (eg 6:00-7:00=0:04:39) which means roughly that they've clocked in at 6:54, and then it follows to 15:00-4:00=0:01:05. I have 60 employees that I have to enter information for every day. Is there a formula that would allow me to even enter data such as 7:00 - 0:04:39? I can't seem to figure a way to work that out! Secondly, I need to create an ongoing monthly average table. Before data is entered into a function, it auto-populates with all zero's and I can't seen to get an average without them. COUNTIF >O doesn't seem to work. Any suggestions??