Converting total summed into hh:mm

[claude jerry]

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

 

[Bob Phillips]

Format it as [h]:mm

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[MartinW]

Hi Claude,

Try,
G2 =SUM(A2:F2)/60/24

and format G2 as custom [h]:mm
or alternatively as custom [h] "hrs" mm "mins"

HTH
Martin

 

[claude jerry]

Thanks
Worked very well

Hi Claude,

Try,
G2 =SUM(A2:F2)/60/24

and format G2 as custom [h]:mm
or alternatively as custom [h] "hrs" mm "mins"

HTH
Martin

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