Hello all

I have a work sheet which shows minutes worked by an employee

A B C D E F G
30 30 0 30 30 60 180

Col A to F shows hours worked in minutes eg. 30 min 60 min etc
Col G =Sum(A2:F2) calculates total time worked for the week

I want Col G to show totals in Hours HH.MM eg 3Hrs

Thanks In advance