Both columns F & G are set as h:mm

"Teethless mama" wrote:

Format as: [h]:mm


"blindmanwalks" wrote:

Hi All,

I am sure this is going to be simple for someone but I am coming up blank on
what to do.

I have an excel worksheet which calculates the amount of time an employee
works per day and then it adds it up for a two week pay period.
I have two columns dedicated for "In" & "Out" and then one for Daily Hours
and one for Weekly Hours. Everything was going well until you get to 24 hours
and then it sets to 0:00 and after that starts counting from 1 again.
Daily is computed by End - Start and then Weekly is computed by the
following error formula =IF(ISERR(G8+F9),"",G8+F9) - G being weekly and F
Daily Hours. When I sum it up it comes up with the correct amount of hours.
=SUM(F8:F21)*24
However, the column with the weekly hours is the one that is coming up
incorrect.

Can someone please help me. Two screen shots can be found at the links below.
Excel Sheet -
http://i10.photobucket.com/albums/a1...esheet.pngWith
Formuals Shown -
http://i10.photobucket.com/albums/a1...thformulas.png

Any Help would be greatly appreacited. Thanks