Posts by scarlett_b

    Re: Time Sheet Formula

    Quote from MrRedli;771218

    you will need to change the cell format [h] "Hours" mm "Minutes" with h in square bracket

    Thanks. That seems to have solved the issue.

    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.