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!