TIME : MINUTES = HOURS

[verluc]

I have a sheet with in column A1:A20 fillid with minutes.I want a formale that gives me in cell A21 the sum in hours and minutes:
EX:

120
75
20
150

SUM : 6,12

Many thanks

[kinkyparamour]

Not sure but I am thinking =sum(a1:a20)/60
format cell as number......

Denny

[ This Message was edited by: kinkyparamour on 2002-04-12 08:28 ]

[ This Message was edited by: kinkyparamour on 2002-04-12 08:29 ]

[Brian from Maui]

Try
=sum(a1:a20)/1440

Example you gave should be 6 hours 5 mins

Format A21 to time

[ This Message was edited by: Brian from Maui on 2002-04-12 08:33 ]

[Steve Hartman]

=SUM(A1:A20)/1440 and format cell as h,mm. for the data you provided this displays 6,05

[kinkyparamour]

Hi Guys,

I see where your formula is right and mine is way off. Could you please explain what the 1440 represents?

Denny

[Brian from Maui]

On 2002-04-12 08:53, kinkyparamour wrote:
Hi Guys,

I see where your formula is right and mine is way off. Could you please explain what the 1440 represents?

Denny

1440 is the number of minutes in a day

[kinkyparamour]

Thank you, now it makes sence to me.....Sometimes it's the little things that get in the way.....

Denny

[ This Message was edited by: kinkyparamour on 2002-04-12 09:03 ]

[gareth]

OK Here is a good example of a function which I use to convert time on my payrolls

=INT(E10/60)&" hours "&MOD(E10,60)& " minutes"


the E10 is where the minutes is

It will give you exp.18hours15minutes

And when you devide it by 60 it will give you 18.3333333 which is 18 and a third which is wrong.

[gareth]

OK Here is a good example of a function which I use to convert time on my payrolls

=INT(E10/60)&" hours "&MOD(E10,60)& " minutes"


the E10 is where the minutes is

It will give you exp.18hours15minutes

And when you devide it by 60 it will give you 18.3333333 which is 18 and a third which is wrong.