M
Msobral
I'm creating a weekly hours log for our techs, so they split
their time between customers. The entries look pretty much like this:
Cutomer Day Date Task Hours
Smith Tuesday 07/03/07 Work on VOIP 2.5
Johnson Thursday 07/05/07 PC Setup 4.0
Weekly Total 6.5
Now I want to have the following:
Hrs Worked per Day
Sat Sun Mon Tue Wed Thu Fri
0 0 0 2.5 0 4.0 0
In Excel I could use : SUMIF (range, criteria,sum_range) Any ideas on what
to use in Info Path?
their time between customers. The entries look pretty much like this:
Cutomer Day Date Task Hours
Smith Tuesday 07/03/07 Work on VOIP 2.5
Johnson Thursday 07/05/07 PC Setup 4.0
Weekly Total 6.5
Now I want to have the following:
Hrs Worked per Day
Sat Sun Mon Tue Wed Thu Fri
0 0 0 2.5 0 4.0 0
In Excel I could use : SUMIF (range, criteria,sum_range) Any ideas on what
to use in Info Path?