Excel Functions

[shadylady]

I have calculated a time sheet using nautical time. I
have been successful in creating a formula that adds the
hours together, subtracts for lunch hours and breaks and
give the total of hours at the end of the day. Most days
it is 8:00 hours. At the end of the week I would like to
add the total of the hours to come up with a weekly
total. In this case it would be 40 hours. Is there a way
to do that?

 

[JohnI in Brisbane]

shadylady,

Just try adding up the times as usual, BUT use the following format for the
answer,

[h]:mm

This format allows the display of hours greater than 24. Using the normal
format doesn't.

regards,

JohnI