Converting total summed into hh:mm
 

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

Converting total summed into hh:mm
 

Format it as [h]:mm

--
HTH

Bob

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

"claude jerry" wrote in message
...
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

Converting total summed into hh:mm
 

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" wrote in message
...
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

Converting total summed into hh:mm
 

Thanks
Worked very well

"MartinW" wrote:

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" wrote in message
...
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