Hi, each month I create an excel worksheet for the total amount of hours
attended at work. I have formatted the cells to show the start and finish
time in 13:00 format. I then subtract start from finish to get the total
hours for that day. In another cell I add up the total hours during 31 days
to get the month's total.

The problem is that I then have to subtract the total obligatory hours from
the total hours of actual attendence. If i have hours missing, only #########
symbols are displayed and not the actual amount of hours missed. This
totally destroys the whole point of the exercize. (If I format the cell to
"general" then the total is completly wrong).

How do I remedy this? I use Office 2003 with Windows XP. Would greatly
appreciate your help. Many thanks!

Change the date system to 1904, Tools|Options|Calculation, and check 1904
system date.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Josh W" wrote in message
...
Hi, each month I create an excel worksheet for the total amount of hours
attended at work. I have formatted the cells to show the start and finish
time in 13:00 format. I then subtract start from finish to get the total
hours for that day. In another cell I add up the total hours during 31
days
to get the month's total.

The problem is that I then have to subtract the total obligatory hours
from
the total hours of actual attendence. If i have hours missing, only
#########
symbols are displayed and not the actual amount of hours missed. This
totally destroys the whole point of the exercize. (If I format the cell
to
"general" then the total is completly wrong).

How do I remedy this? I use Office 2003 with Windows XP. Would greatly
appreciate your help. Many thanks!

Thanks Bob. However, when I do this, I get the completely wrong result!!

"Bob Phillips" wrote:

Change the date system to 1904, Tools|Options|Calculation, and check 1904
system date.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Josh W" wrote in message
...
Hi, each month I create an excel worksheet for the total amount of hours
attended at work. I have formatted the cells to show the start and finish
time in 13:00 format. I then subtract start from finish to get the total
hours for that day. In another cell I add up the total hours during 31
days
to get the month's total.

The problem is that I then have to subtract the total obligatory hours
from
the total hours of actual attendence. If i have hours missing, only
#########
symbols are displayed and not the actual amount of hours missed. This
totally destroys the whole point of the exercize. (If I format the cell
to
"general" then the total is completly wrong).

How do I remedy this? I use Office 2003 with Windows XP. Would greatly
appreciate your help. Many thanks!

Unless you're just commenting for the heck of it, it would have been
helpful to indicate what your formula is, what the referenced cell
values are, and what you expected the result to be...

In article ,
Josh W wrote:

Thanks Bob. However, when I do this, I get the completely wrong result!!

Wow! What an attack...I thought I had explained well in the beginning. In
the end I formatted each cell as [hh]mm and changed to 1904 date system and
it seems to be working.

"JE McGimpsey" wrote:

Unless you're just commenting for the heck of it, it would have been
helpful to indicate what your formula is, what the referenced cell
values are, and what you expected the result to be...

In article ,
Josh W wrote:

Thanks Bob. However, when I do this, I get the completely wrong result!!

What attack? You posted back to a suggested solution with no info except
that you got a completely wrong result. One would expect a description of
what was wrong with the result vis-à-vis the result you expected.


--
Regards,

Peo Sjoblom



"Josh W" wrote in message
...
Wow! What an attack...I thought I had explained well in the beginning. In
the end I formatted each cell as [hh]mm and changed to 1904 date system
and
it seems to be working.

"JE McGimpsey" wrote:

Unless you're just commenting for the heck of it, it would have been
helpful to indicate what your formula is, what the referenced cell
values are, and what you expected the result to be...

In article ,
Josh W wrote:

Thanks Bob. However, when I do this, I get the completely wrong
result!!