MrExcel Publishing
Your One Stop for Excel Tips & Solutions

SPECIAL TIME CALCULATION NEEDED - HELP


Posted by EDDIE G on October 17, 2001 6:49 PM

If this is possible, I need a formula that will do the following: I have a time sheet with standard start time, lunch in, lunch out, and end time. Calculating the total time worked in hours and minutes is easy, but in the next column, I need a formula that will will show the total time in this format: 7.2 , 7.3, 7.4 etc. In other words, each six minute increment is 1/10 of an hour. Here trick is this however; if the the the time is one minute past the increment, it should show as the next increment. Example: if the total hours worked is 8 hours 8 minutes, then the result should be 8.2 hours, not 8.1 hours. Can this be done? THANKS


Posted by Travis Harr on October 17, 2001 7:10 PM

=ROUNDUP((C1-INT(C1))*24,1) Where C1 is the cell with total time