calculate percentage of scheduled hours

[NareshN]

Hi,

I have weekly wise scheduled hours of each employee and no of days scheduled for each employee,now i need to calculate no of employees scheduled less than 24 hours,no of emp's scheduled b/w 24 and 48 hrs and emp's scheduled more than 48 hrs in percentage for fisrt week,second week,3rd week and 4th week.
Like this
SCheduled Hrs 8/1/2010 8/8/2010 8/15/2010 8/22/2010

Less tha 24 hrs 5% 5% 5% 5%

b/w 24 and 48 hrs 4% 5% 5% 5%

>48 91% 90% 90% 90%

[MrMancunian]

So what's your question?

Steven

[NareshN]

I just want to calculate weekly wise reports.

Reports should be for less than 24 hrs,betweeb 24 and 48 hrs and >48 hrs for all 4 weeks

I have reports like this in database for each employee

8.1.2010 8.8.2010 8.15.2010 8.22.2010
Emp1 24:00 24:00 24:00 22:00
Emp2 48:00 48:00 42:00 48:00
..
..
..
Empn

[Frinavale]

Is the data stored in a database?
This is pretty easy to do with SQL Queries...

-Frinny

[NareshN]

Hi,

i have hours scheduled in a day and no of days scheduled in a week for each employee, based on this i will calculate hours scheduled for first week,2 week,3rd and 4th.

please send me query to get reports for hours scheduled less than 24,b/w 24 and 48 and >48 hrs for 1st week,2nd week,3rd week and 4th week

[Frinavale]

NareshN,

The epxerts here on Bytes are not in the habit of doing your work for you. We are here to give you a hand with specific problems that you may be facing. It's unlikely that anyone is going to "give you queries" for your reports...especially if you haven't attempted to run the reports yourself yet.

Also, it is very hard to help you if you don't tell us how or where the data is stored.

Is it stored in a database?
If so, you can use SQL queries to return you the information.

But this isn't the only option...you could just use a SQL query to return you all of the data and then implement logic that does the calculations in your VB.NET or C# code. You could use LINQ to do this, or you could just use simple loops.

Please show us what you have attempted to solve the problem so far, and also provide us with more information about where/how the data is stored.



-Frinny