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
Start Date	Current Date	Months	Accrual	Vac Used	Balance
or

<colgroup><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"]10-Oct-16[/TD]
[TD="align: right"]30-Jan-18[/TD]
[TD="align: right"][/TD]
[TD="align: right"]160.05[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]110.05[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]1-Nov-17[/TD]
[TD="align: right"]30-Jan-18[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]21.34[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]21.34[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

3ddd​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E2[/TH]
[TD="align: left"]=DATEDIF(B2-1,C2,"m")*10.67[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D3[/TH]
[TD="align: left"]=DATEDIF(B3-1,C3,"m")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E3[/TH]
[TD="align: left"]=D3*10.67[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G2[/TH]
[TD="align: left"]=E2-F2[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G3[/TH]
[TD="align: left"]=E3-F3[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



10 hours and 40 minutes equals 10.67 hours

Thank you! I will give this a try today!

 

[Supermom1]

Thanks so much! This worked