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

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

Actually what I need to know is this .. I want to 40 hours worked in one
column, 30 hours paid in another .. then I will subtract the 30 from the 40
... this is an example .. I won't be using times .. I might 38.25 worked -
30.00 paid .. do I just use regular number formatting?

Thanks Mike for answering .. :)

"Mike H" wrote:

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

If you are just working in decimal hours, not in Excel times, then don't use
a time format; use General or Number.
--
David Biddulph

"hrbsh97" wrote in message
...
Actually what I need to know is this .. I want to 40 hours worked in one
column, 30 hours paid in another .. then I will subtract the 30 from the
40
.. this is an example .. I won't be using times .. I might 38.25 worked -
30.00 paid .. do I just use regular number formatting?

Thanks Mike for answering .. :)

"Mike H" wrote:

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