In correct total for " Hours" and in fractions

[Karnik]

Hello,
I am working on "time Sheet" trying to add numbers of hours in a totals.

When I total for the week I get recurring decimals see below and one total shows 75 minutes, I cannot get correct.

System : Windows 7, Excel 2007
Function used MOD(cell range,1)*24 and general format
Cell format tried HH:MM and number, general

please guide where am I going wrong see following table:

................Meal Break
Start Time From To Finish Time Hours Worked
8:30 AM 1:00 PM 1:45 PM 4:30 PM 7:15
8:30 AM 1:15 PM 2:00 PM 4:30 PM 7:15
8:35 AM 1:15 PM 1:45 PM 4:35 PM 7:30
8:10 AM 1:00 PM 1:30 PM 4:15 PM 7:35
8:10 AM 1:00 PM 1:45 PM 4:30 PM 7:35
TOTAL 37.16666667
............Meal Break
Start Time From To Finish Time Hours Worked
8:20 AM 12:30 PM 1:00 PM 4:30 PM 7:40
8:20 AM 1:10 PM 1:40 PM 4:30 PM 7:40
8:15 AM 1:30 PM 2:00 PM 4:30 PM 7:45
8:30 AM 1:00 PM 1:45 PM 4:30 PM 7:15
8:35 AM 12:30 PM 1:00 PM 4:30 PM 7:25
TOTAL 37.75

 

[p45cal]

Try format:
[HH]:mm