sum minutes
I am tring to sum up a row of minutes hoever I am having a problem with 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? -- parteegolfer ------------------------------------------------------------------------ parteegolfer's Profile: http://www.excelforum.com/member.php...o&userid=31951 View this thread: http://www.excelforum.com/showthread...hreadid=537913 |
sum minutes
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 |
sum minutes
this worked out well.........THANKS. One other question. Where does the value 1440 come from? -- parteegolfer ------------------------------------------------------------------------ parteegolfer's Profile: http://www.excelforum.com/member.php...o&userid=31951 View this thread: http://www.excelforum.com/showthread...hreadid=537913 |
sum minutes
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 |
All times are GMT +1. The time now is 10:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com