Ask Experts Questions for FREE Help !
Ask
    mathan_ae's Avatar
    mathan_ae Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Sep 8, 2010, 11:26 PM
    How can I distribute total hours between two dates into respective weeks
    Hi.

    I am about to prepare a Project Weekly Report in which I have distribute Total Hours of particular task into weekly hours in respective weeks. For example if a task is taking totally 50 hours between a particular start date and end date, how to I distribute this in weekly basis (Week 2 is having 20 hours, Week 3 is having 20 hours, Week 4 is having 10 hours.. Like that). Please help.

    Thanks
    Mathan
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Sep 9, 2010, 10:12 AM

    Without more information about how you would "automate" this decision-making model and a look at your workbook, I'd say it's a manual process, isn't it?
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to calculate total hours from a given time in excel [ 1 Answers ]

How to calculate the total hours worked from the excel with the help of in time and out time

Excel Total Hours Forumla Work Schedule [ 2 Answers ]

Hi, I'm having trouble figuring out how to find the total hours of a schedule for employees. Basically, the Rows are the days of the week and the columns are names, and the times fall in the middle. The problem is the a(AM) and p(PM) are necessary because it is a 24-hour store... ...

Total hours from selected records [ 1 Answers ]

I have one table and the fields are start time and end time. I'm already find working hours from stime and etime. But I want total working hours for selected records. i.e I want total hours for 10 selected records.. in msacces

View more questions Search