Calculating time

[Erica]

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!

 

[T. Valko]

Just use the SUM function:

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

Format as [h]:mm

 

[Erica]

This worked... THANK YOU!!!!!

Just use the SUM function:

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

Format as [h]:mm

--
Biff
Microsoft Excel MVP

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!

 

[T. Valko]

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP

This worked... THANK YOU!!!!!

Just use the SUM function:

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

Format as [h]:mm

--
Biff
Microsoft Excel MVP

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!