Calculate Total Hours Worked For Week Based On Check Boxes.

P

Pablito

Hi,
I created a Scheduling database. On the scheduling form I have fields for
"the time the person started work", "the time the person ended work", "total
hours for the week" and check boxes for "sun", "mon", "tues", "wed", "thur",
"fri" and "sat". I would like the program to automaticly calculate the total
hours worked for the week based on the amount of check boxes checked. I have
included some of the code I have tried.

=Sum(IIf([SUN]=Yes Or [MON]=Yes Or [TUE]=Yes Or [WED]=Yes Or [THU]=Yes Or
[FRI]=Yes Or [SAT]=Yes,DateDiff("n",[START_TIME],[END_TIME])/60))

Any help with this wil be greatly appreciated!

Thank you,
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Week number 1
Help to Highlight Excel Row based on Weekly Date Range 2
Main form- subform for -logging hours worked for day/week 2
Excel help recording hours 1
Need Formula to Calculate Time/Overtime 2
Finding number of weeks within a period 1
How do I get a total work hours by a week phases 0
Function to calculate total hours worked in one week. 5

Top