Check this link out. Ken has some cool tools for doing just about everything w/ dates and hours.
Its a good place for you to start for coming up with a method for your hours.
Even to ignore weekends and holidays.
Â
http://www.kenhamady.com/form13.shtml%c2%a0
---------------
Jim Chance, PMP - IT consultant/contractor
DBA Practical Technology Solutions
1485 County Road 1575
Ashland, Ohio, 44805
Office/Home: 419-557-2225
Cell: 419-651-6704
Fax: 732-601-6704
Email: jim_chance@...
PMP Certified, IT purveyor since 1985. SQL Server, Crystal, Project Management, HP3000, UNIX, Migrations/Conversions, ERP expert.
Primary strengths:
1) IT in manufacturing 2) Analyst 3) ERP 4) MS SQL 5) Crystal reports
Robust SDLC experience. Completed the development & implementation of over 1200 application solutions to-date. PMP, Project Management Professional credential by PMI. Strong development, analysis and integration skills. Sarbanes Oxley knowledge. Single handedly converted legacy systems to MS SQL multiple times. Broad understanding of capital projects. Experienced hands-on analyst who has also managed budgets, work plans, schedules, deliverables and responsibility matrices. Additionally, set objectives, build, track and monitor project plans using MS Project with PMBOK methodologies. Used integration, technical and negotiation skills to achieve successful project outcomes around issues, scope, schedule, costs and resources.
Rent our condo in sunny warm Estero, Florida:
http://www.vacationrentals.com/vacation-rentals/23683.html
From: mmcwilliams22 <mmcwilliams22@...>
Its a good place for you to start for coming up with a method for your hours.
Even to ignore weekends and holidays.
Â
http://www.kenhamady.com/form13.shtml%c2%a0
---------------
Jim Chance, PMP - IT consultant/contractor
DBA Practical Technology Solutions
1485 County Road 1575
Ashland, Ohio, 44805
Office/Home: 419-557-2225
Cell: 419-651-6704
Fax: 732-601-6704
Email: jim_chance@...
PMP Certified, IT purveyor since 1985. SQL Server, Crystal, Project Management, HP3000, UNIX, Migrations/Conversions, ERP expert.
Primary strengths:
1) IT in manufacturing 2) Analyst 3) ERP 4) MS SQL 5) Crystal reports
Robust SDLC experience. Completed the development & implementation of over 1200 application solutions to-date. PMP, Project Management Professional credential by PMI. Strong development, analysis and integration skills. Sarbanes Oxley knowledge. Single handedly converted legacy systems to MS SQL multiple times. Broad understanding of capital projects. Experienced hands-on analyst who has also managed budgets, work plans, schedules, deliverables and responsibility matrices. Additionally, set objectives, build, track and monitor project plans using MS Project with PMBOK methodologies. Used integration, technical and negotiation skills to achieve successful project outcomes around issues, scope, schedule, costs and resources.
Rent our condo in sunny warm Estero, Florida:
http://www.vacationrentals.com/vacation-rentals/23683.html
From: mmcwilliams22 <mmcwilliams22@...>
>To: vantage@yahoogroups.com[Non-text portions of this message have been removed]
>Sent: Thursday, July 28, 2011 12:50 PM
>Subject: [Vantage] Crystal hours left in weeks
>
>
> Â
>
>I am trying to figure out how I can determine how many hours are left in a week using a formula in crystal.
>
>I have a report grouped by week, for each previous week it should be zero, for each future week it should be all hours and for the current week it should determine how many hours are left.
>
>To take it one more step I would like to do Monday through Friday only.
>
>There has to be a way to do this, correct?
>
>
>
>
>