Hi, I have a couple of questions here. I'm working on a timesheet for work. I'm trying to figure out how to make it calculate properly. I clock in my time when i arrive and when I leave. It calculates hours and minutes worked every day, and total hours and minutes at the end of the week. when it adds the hours and minutes for the whole week, i think its calculating wrong. Like, if i work 7 hours 45 minutes monday, 7 hours 30 minutes tuesday, and 7 hours 45 minutes on wednesday, when excel adds that up it comes to 22 hours and 20 minutes. If you add it on paper, and rounding at 60 instead of 100 (for 60 minutes/hour) it comes to 23 hours. What formula will make it calculate correctly?