Add Up Hours in Timesheet

[hermes980]

Hello all,

I have developed a timesheet that allows you to enter the work done by date.
In any given day, there may be 5 tasks completed. The timesheet is used on a
weekly basis so that at the end of the week I have the total hours displayed.

What I would like to do is break out the hours worked per day, rather than
per week. Is there a way to display a date as the day of the week? and if so,
how can I have these added up so that they daily work hours are caculated?
Currently, I display the day of the week by using a sharepoint list that has
a date field and the day of week that belongs to that date. I then have a
formula in infopath that basically states "if the date selected in the
infopath date picker equals the date in the list, display the day of the week
from the list". The problem is, when I test this method and try and enter
time from a day in the past, the day of the week gets stuck and will not
change when I enter a new record. Any help is appreciated.

Thanks!

 

[S.Y.M. Wong-A-Ton]

I'm not entirely clear on your scenario, but you can use the formula listed
in this article
http://enterprise-solutions.swits.n...date-picker-infopath-using-rules-formulas.htm
to calculate a number that represents the day of the week corresponding to a
date. You can then use rules to 'translate' those numbers to words, e.g.
create a formula that will show the text "Sunday" when the results of the
formula is 0, etc.

 

[hermes980]

Thanks for the direction. I actually ended up using separate lists for each
day of the week that had every date for every Monday, Tuesday, etc. until
2015. I then doing a comparision between the date picker date and the list
date to select the day of the week and then sum up the hours. It is working
great so far.

Regards.