sum minutes

P

parteegolfer

I am tring to sum up a row of minutes hoever I am having a problem wit
the formats and formulas.

example : a1=15
b1=30
C1=10
D1=45

and sum up in E1 to = 1:40

How can I achive this
 
V

vezerid

You can use in E1:

=SUM(A1:D1)/1440

and format as h:mm or [h]:mm

This assumes that you will always entering minutes as integers in
A1:D1. You can enter them as minutes like

0:15

Now you don't have to divide the SUM() by 1440. Use a similar format.
[h] will show hours in excess of a day as 35:43.

HTH
Kostis Vezerides
 
P

parteegolfer

this worked out well.........THANKS. One other question. Where does the
value 1440 come from?
 
V

vezerid

1440 = 24*60, i.e. the number of minutes in a day. Dates are stored as
numbers in Excel, Jan 1, 1900 being number 1 and increasing by one day
since. So VALUE(TODAY()) = 38839. Time is stored as fractional part. So
noon today is VALUE(TODAY()+0.5) = 38839.5.

By this token, if you enter your minutes as integers, they have to be
converted into the quantity that Excel thinks as a minute, which is
1/1440. Then you sum these quantities and you get a number probably
much smaller than 1. If you format this as time you will see it as
minutes.

Does this help?

Kostis
 
Top