Formula in Excel 2007

[Ramesh_vm]

Hi i have created 1 Excel sheet for my team where in there are 10 different sheets(Sheet1,Sheet2,Sheet3.... Sheet10). There is 1 Sheet which has consolidate for all 10 of them in 1 sheet (i.e Consolidated). So i need to us a formula in which it should show :

Training Requirement =32 hours a year

8 hours a quarter (3 months)

or 2.67 hours a month.


How can i do that and which formula can be used.

Is that possible ..?


Much appreciate your help.


Best Regards,

Ram…

 

[Kevin@Radstock]

Hi Ramesh_vm


Can you not divide the Training Requirement (Hours) by the the number of months (For this case 1 year)


=32/12

 

[Ramesh_vm]

Hi Kevin...

No, On Quaterly basis the trainigs hours should be 8hrs....or else can i make it like this or can u have any other option.Bit the @ year end it should complete 32hrs or can be more also.

[pre]

Name of Employee	Jan	Feb	March	Total
Shekhar 				          8hrs
Rakesh				                  8hrs
Raj K				                  8hrs
Ram P				                  8hrs
Subodh				                  8hrs
Ajay				                  8hrs

[/pre]