Time Accrued Formula

[Supermom1]

Hello there! I'm having problems coming up with an excel formula for my office. We get 10 hours and 40 minutes a month and work 8 hour days. It needs to calculate how much time accrued as well as used from the date of hire. Any help with formatting and a formula would be greatly appreciated!

 

[Dave Patton]

Excel 2010
	A	B	C	D	E	F	G
1		Start Date	Current Date	Months	Accrual	Vac Used	Balance
2		10-Oct-16	30-Jan-18		160.05	50	110.05
3	or	1-Nov-17	30-Jan-18	2	21.34	0	21.34
4
3ddd

Cell Formulas
Range	Formula
E2	=DATEDIF(B2-1,C2,"m")*10.67
E3	=D3*10.67
D3	=DATEDIF(B3-1,C3,"m")
G2	=E2-F2
G3	=E3-F3

10 hours and 40 minutes equals 10.67 hours

 

[Supermom1]

Excel 2010

	A	B	C	D	E	F	G
1		Start Date	Current Date	Months	Accrual	Vac Used	Balance
2		10-Oct-16	30-Jan-18		160.05	50	110.05
3	or	1-Nov-17	30-Jan-18	2	21.34	0	21.34
4

<colgroup><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

3ddd​

Worksheet Formulas Cell Formula E2 =DATEDIF(B2-1,C2,"m")*10.67 D3 =DATEDIF(B3-1,C3,"m") E3 =D3*10.67 G2 =E2-F2 G3 =E3-F3 <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

10 hours and 40 minutes equals 10.67 hours

Thank you! I will give this a try today!

 

[Supermom1]

Thanks so much! This worked