What is the formula for figuring out time? I am creating a time sheet and I want it to automatically figure out the hours per day that I work. I have entered a few different formulas but they are not giving me the results I want. I always end up with .08 hours instead of 8 hours. The formula I am trying to write is – Start Time to Lunch Time, then After Lunch to Quitting Time. I also need a formula for overtime. Something saying if the regular time in more than 8 hours then…. Any help is greatly appreciated. Thanks!
