I have created a time sheet to calculate the total hours worked each day in decimal format and also in "hours" and "minutes". I have been using the following formula in the column to calculate hours and minutes.
=CONCATENATE(INT(G9)," hours ",INT(MOD(G9,1)*60)," minutes")
It works fine to calculate the daily hours, but when it calculates the total weekly time, it adds one minute to the total. Is there a way to edit the existing formula to prevent this? Or is there a better formula that I should be using? I have attached a copy of my file.