Calculating task duration, hours spent on task, remaining hours

[aronax_1]

Hey,

Need your help asap. It would mean a lot to me.

I have the following information:

- employees that work 20 hours/week;

- 100 hours/project;

- employees are assigned activities that have a start date and a due date;

- start date and completed dates are formatted as date, type 2014.07.13 14:00.

- several activities overlap each other

- I need help with a formula that calculates task duration, hours spent on task, remaining hours.

Help!


Thanks!

Task ID Task List Milestone Task Name Task Description Start Date Due Date Priority Private Progress Status Assigned To Date Created Completed Date Completed By Firstname Completed By Lastname Parent Task Task duration Hours spent on task Remaining hours 1225050 Inbox Make google doc of all materials ordered. 11/07/2014 18/07/2014 0 0 new Smith F. 2014-07-10 16:09:53.0 1049038 Office Admin tasks Sell surplus furniture on ebay 26/05/2014 18/06/2014 0 0 completed Smith F. 2014-06-04 09:53:11.0 2014-06-20 17:32:50.0 Smith Fendis 1076081 Office Admin tasks Sort out furniture in office Home Furniture | eBay 0 0 reopened Smith F. 2014-06-09 10:46:21.0 2014-06-20 17:32:46.0 Smith Fendis 1079949 Office Admin tasks Log incoming Invoices 0 0 completed Smith F. 2014-06-10 10:03:34.0 2014-06-20 17:32:45.0 Smith Fendis 1085658 Office Admin tasks - Smith Move todo lists onto Teamworker 11/06/2014 18/06/2014 0 0 completed Smith F. 2014-06-11 14:51:12.0 2014-06-23 13:24:36.0 Smith Fendis 1085654 1085925 Office Admin tasks Clear Russells desk 11/06/2014 16/06/2014 0 0 completed Smith F. 2014-06-11 16:31:29.0 2014-06-19 10:24:14.0 Smith Fendis <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col span="3"></colgroup><tbody> </tbody>

<tbody>
</tbody>

 

[oldbrewer]

do employess only work monday to friday and only work 4 hours per day or could they work 7 hours one day and only one hour another day

you need a helper cell with = today() in it to give current date and time
it is then about checking if task is complete and was it finished early, on time or late
if not complete, is scheduled completion date less than =today()

also do all employees work same time eg 09:00 to 13;00