You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Erica" wrote in message
...
This worked... THANK YOU!!!!!

"T. Valko" wrote:

Just use the SUM function:

=SUM(J9,M9,P9,S9,V9,Y9,AB9)

Format as [h]:mm

--
Biff
Microsoft Excel MVP


"Erica" wrote in message
...
I am working on a spread sheet and I need it to calculate the hours
worked
based on the clock in/out time... This is the formula that I have used:
=IF(((I9-H9)*24)=5,I9-(H9+TIME(0,30,0)),I9-H9)
and it works...
But now I need to add the time worked for all 7 days (2 of which are
zero
but have the formula in the cell). I tried =TIME(j9+m9,"h") and it will
work
for only 2 cells at a time, however I need to calculate the entire week
(7
cells)...
Please help...
THANK YOU!