Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
Is it possible to convert a number into hours and minutes | Excel Worksheet Functions | |||
How do I sum increments of minutes and seconds | Excel Worksheet Functions | |||
adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
AutoSave: How can I get it to save every 5 minutes & NO prompt? | Excel Worksheet Functions |