_____|__IN__|__OUT__|__IN__|__OUT__|__TOTAL__|

Date:|_7:05____12:13____12:46___5:28______10_____

Date|___________________________________10_____

Date|___________________________________10_____

~

~

Weekly total______________________________30______

So we work 7:00am to 5:30pm with a half hour lunch 3 days a week. HR wants us to write the time exactly when we punch in and out but to round to the nearest quarter hours for our daily total in decimal format. For instance anything below :06 rounds down and anything above :07 round up so 7:06 is 7.00 and 7:07 is 7.25. what I want to do is have the TOTAL column auto calculate the time worked for the day and automatically round to the nearest quarter hour in decimal form so say I worked 10hrs:7min it would round that to 10:15 and convert it 10.25

Any help is very appreciated as I am almost clueless to excel commands and such. Thanks much.