Weekly TimeSheet Template total of week hour problem

Asked By Colten 0 points N/A Posted on - 11/22/2011

Hello,

For weekly hours I am using Microsoft Weekly TimeSheet Template. For the first time I am having this big problem that I can't solve. My is total of weekly hours. All relevant information I have entered in cells activity, shift, days and total.

But when I press enter with the last information I got error message.

Can someone please help me, I don't know what I have done wrong?

Thank you

Colten

The page at htp://staginga.wetimesheet.intranet.replicon.com says:

Error: The timesheet hours do not meet one or more of the following validation requirements

Work Week total should be less than or equal to 58.0000 hour(s)

• Status: Open
• Question Views: 936
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Suresh-paliwal 0 points N/A #113620

Weekly TimeSheet Template total of week hour problem

This is a template and fix to give an error if total more than 58 hours. Go back and fill in the day’s field with appropriate value of hours. Know that Total must be 58 hours, or less than 58.

                                  If you want to fill more than 58 in total then remove this total field completely and create again. In total cell give this formula =cell no. Below s29 and again Total row+cell no. On below m30 and again Total row+cell no. Below t1 and again Total row+ cell no. Below w2 and again Total row+cell no. Below t3 and again Total row+cell no. Below f4 and again Total row+cell no. Below s5 and again Total row. After doing this you will see the right total without errors.

About Suresh-paliwal

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 11/25/2011
• Question Category: MS Excel