MID Function confusion

[sumsaam]

Hi friends
I have time values of my staff from attendance machine in an excel file and want to compile the results for calculating salary automatically,
i get values from other sheet by help of MID, my formulas were not working on that time values somebody helped me to put -- (two negative signs) with MID function. in some places MID is not used. is there any way to change the values in numbers of whole sheet. my problem is that how to correct value where mid is not used. thank you

 

[oldbrewer]

[TABLE="width: 841"]
<colgroup><col><col><col span="5"><col><col><col span="3"></colgroup><tbody>[TR]
[TD]name[/TD]
[TD]date[/TD]
[TD]clock in[/TD]
[TD]clock out[/TD]
[TD]dec hours[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]alan[/TD]
[TD="align: right"]04/12/2018[/TD]
[TD="align: right"]06:41[/TD]
[TD="align: right"]14:03[/TD]
[TD="align: right"]7.37[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]bill[/TD]
[TD="align: right"]04/12/2018[/TD]
[TD="align: right"]06:42[/TD]
[TD="align: right"]14:05[/TD]
[TD="align: right"]7.38[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]fred[/TD]
[TD="align: right"]04/12/2018[/TD]
[TD="align: right"]06:43[/TD]
[TD="align: right"]14:07[/TD]
[TD="align: right"]7.40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]alan[/TD]
[TD="align: right"]05/12/2018[/TD]
[TD="align: right"]06:44[/TD]
[TD="align: right"]14:09[/TD]
[TD="align: right"]7.42[/TD]
[TD][/TD]
[TD][/TD]
[TD]Sum of dec hours[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]bill[/TD]
[TD="align: right"]05/12/2018[/TD]
[TD="align: right"]06:45[/TD]
[TD="align: right"]14:11[/TD]
[TD="align: right"]7.43[/TD]
[TD][/TD]
[TD][/TD]
[TD]name[/TD]
[TD]Total[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]fred[/TD]
[TD="align: right"]05/12/2018[/TD]
[TD="align: right"]06:46[/TD]
[TD="align: right"]14:13[/TD]
[TD="align: right"]7.45[/TD]
[TD][/TD]
[TD][/TD]
[TD]alan[/TD]
[TD="align: right"]37.33333333[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]alan[/TD]
[TD="align: right"]06/12/2018[/TD]
[TD="align: right"]06:47[/TD]
[TD="align: right"]14:15[/TD]
[TD="align: right"]7.47[/TD]
[TD][/TD]
[TD][/TD]
[TD]fred[/TD]
[TD="align: right"]37.5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]bill[/TD]
[TD="align: right"]06/12/2018[/TD]
[TD="align: right"]06:48[/TD]
[TD="align: right"]14:17[/TD]
[TD="align: right"]7.48[/TD]
[TD][/TD]
[TD][/TD]
[TD]bill[/TD]
[TD="align: right"]37.41666667[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]fred[/TD]
[TD="align: right"]06/12/2018[/TD]
[TD="align: right"]06:49[/TD]
[TD="align: right"]14:19[/TD]
[TD="align: right"]7.50[/TD]
[TD][/TD]
[TD][/TD]
[TD]Grand Total[/TD]
[TD="align: right"]112.25[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]alan[/TD]
[TD="align: right"]07/12/2018[/TD]
[TD="align: right"]06:50[/TD]
[TD="align: right"]14:21[/TD]
[TD="align: right"]7.52[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]bill[/TD]
[TD="align: right"]07/12/2018[/TD]
[TD="align: right"]06:51[/TD]
[TD="align: right"]14:23[/TD]
[TD="align: right"]7.53[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]fred[/TD]
[TD="align: right"]07/12/2018[/TD]
[TD="align: right"]06:52[/TD]
[TD="align: right"]14:25[/TD]
[TD="align: right"]7.55[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]alan[/TD]
[TD="align: right"]08/12/2018[/TD]
[TD="align: right"]06:53[/TD]
[TD="align: right"]14:27[/TD]
[TD="align: right"]7.57[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]bill[/TD]
[TD="align: right"]08/12/2018[/TD]
[TD="align: right"]06:54[/TD]
[TD="align: right"]14:29[/TD]
[TD="align: right"]7.58[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]fred[/TD]
[TD="align: right"]08/12/2018[/TD]
[TD="align: right"]06:55[/TD]
[TD="align: right"]14:31[/TD]
[TD="align: right"]7.60[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]calculate hours per day and use a pivot table ?[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]