Thanks:  0
Likes:  0

# Thread: TIME : MINUTES = HOURS

1. 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

2. 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 ]

3. 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 ]

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

5. Hi Guys,

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

Denny

6. 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

7. 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 ]

8. 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.

9. 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.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•