Hi,

As you are establishing it's easy to get in a mess with time if you start
incorrectly formatted.

For times lest then 24 hours format as hh:mm and then remember to enter the
time in the format 8:00 or 6:35. Always use the colon.

For adding time where the sum can be in excess of 24 hours use [hh]:mm and
once again remember the colon when entering the time. Note that this format
can be used for times les than 24 hours.

having start correctly adding and subtracting your times is done using
simple maths operators of + and -.

Mike

"hrbsh97" wrote:

Hi,

I made a spreadsheet to calculate my hours .. here is what I have ..

Week Ending Hours Worked Hours Paid Balance Note

What I put in the number of hours worked in the column, what do I format it
as, I've tried several combinations but nothing seems to work ..

I want to subtract the # of hours paid from # of hours worked to get my
balance ..

I went to Custom & put H:MM .. that didn't work ..

Can someone help me? .. thanks in advance :) ..

Brenda