Multiply and convert minutes to hours

[Panoos64]

Hi all, kindly require to provide me support so that to create a VBA code which should convert the minutes decimals in col. "L" to hours multiplying by 0.60. On my first below extract i appear the original data and on second i appear the expected result.

e.g. 01-Aug-2018 9.67 should be 9.40 (67*0.60=40.20). we get the first decimals (40) and should turn the number 9.67 to 9.40.

Thanks in advance

Original data

​

	A	B	C	D	E	F	G	L
1	CODE	Name	Date	TIME ON DUTY	TIME OFF DUTY	IN	OUT	W. HRS
2	1	EMPLOYEE 1	01-Aug-18	08:00	17:00	7:30	17:10	9.67
3	1	EMPLOYEE 1	02-Aug-18	08:00	17:00	7:45	16:30	8.75
4	1	EMPLOYEE 1	03-Aug-18	08:00	17:00	8:14	17:20	9.10
5	1	EMPLOYEE 1	04-Aug-18	08:00	17:00	7:45	16:14	8.48

<tbody>
</tbody>

Expected result

	A	B	C	D	E	F	G	L
1	CODE	Name	Date	TIME ON DUTY	TIME OFF DUTY	IN	OUT	W. HRS
2	1	EMPLOYEE 1	01-Aug-18	08:00	17:00	7:30	17:10	9.40
3	1	EMPLOYEE 1	02-Aug-18	08:00	17:00	7:45	16:30	8.45
4	1	EMPLOYEE 1	03-Aug-18	08:00	17:00	8:14	17:20	9.06
5	1	EMPLOYEE 1	04-Aug-18	08:00	17:00	7:45	16:14	8.29

<tbody>
</tbody>

 

[steve the fish]

As stated in post number 8 which you have ignored, you can sum time.

 

[Panoos64]

Thank you steve, i express my apologies that, i did not read the post 8 carefully. It appears the "Total Hours" correct now. Many thanks for your time spent for my project. Have a great day!