I am trying to to create a employee time sheet. In day one box an employee puts 1 hour and 30 minutes of work then in day two box they enter in 1 hour and 30 minutes of work. In the total box I need to add up those two boxes to get the total of 3 hours, what is the calculation to do this?
Well this would be alot of work. You have a custom format that would have to split into hours and minutes, convert the hours to minutes, then get the hours and minutes out of the total, and format the output string.
I tried your formula and when I entered 1.33 for 1 hour and 33 minutes of work in day one and then in day two, the total is still 2.66 instead of 3.06. It still doesn't round up. I need to tell it that after .59 (59minutes) then .60 is really 1.00 (one hour).
Lisa, the hour is divided into 1/100 so each minute is 0.01666 and 1 hour 33 minutes would be 1.55.
If you want to enter the time as 1:33 you will need to learn how to split the text string into hours and minutes and then do math with 1 hour equal to 60 minutes, convert the resulting minutes back into hours and minutes and build the text display string.
Lisa, if you have ever used Excel formulas you can use a formula such as SUM("Name of Cell"+"Name of Cell"). You put this formula into cell that contains your total. Make sure to look at the top left hand side of the page to make sure that the drop down box is calculate. Once you have put the formula in, press the "+" sign.
You will have to use the "AT()" function to locate the ":" and split the string into the hours component and then the minutes component. You can then compute the string into minutes. With each string converted to minutes, you can add the minutes getting the total minutes. Now you can easily do the math to get the hours and minutes from the total minutes.