Hour function equivelent help
in [Functions]
|
Prev: Array formulae do not recalculate
Next: Is there a way to "glue" a matrix rectangle of cells together?
From: EAB1977 on 25 May 2010 16:44 If I want to find out how many minutes there are for times that I have summed, I know I can use the hour function if the compiled time is less than 24 hours. But, what if I want to get the times that are over a 24 hour period, how do I do that? Example: 20:57:46 14:39:10 8:57:24 12:12:12 ------------- 56:46:32 <-- the minutes I'd like to get
From: Dave Peterson on 25 May 2010 16:56 You can keep the sum as a time, but give the cell a custom format of:\ [mm] Or you could multiply by hours/day * minutes/hour: =sum(A1:A4)*24*60 and format the cell as General (or number) -- but not time. EAB1977 wrote: > > If I want to find out how many minutes there are for times that I have > summed, I know I can use the hour function if the compiled time is > less than 24 hours. But, what if I want to get the times that are over > a 24 hour period, how do I do that? > > Example: > > 20:57:46 > 14:39:10 > 8:57:24 > 12:12:12 > ------------- > 56:46:32 <-- the minutes I'd like to get -- Dave Peterson
From: "David Biddulph" groups [at] on 25 May 2010 16:59 If you want to see your 56:46:32, but it is displaying as 08:46:32, change the formatting from hh:mm:ss to [hh]:mm:ss If you want to turn 56:46:32 to hours, multiply by 24 and format as General or Number. If you want to turn 56:46:32 to minutes, multiply by 24*60 and format as General or Number. -- David Biddulph "EAB1977" <koolaid4u(a)yahoo.com> wrote in message news:d2a5848c-624d-475f-af92-efa133a173ae(a)c7g2000vbc.googlegroups.com... > If I want to find out how many minutes there are for times that I have > summed, I know I can use the hour function if the compiled time is > less than 24 hours. But, what if I want to get the times that are over > a 24 hour period, how do I do that? > > Example: > > 20:57:46 > 14:39:10 > 8:57:24 > 12:12:12 > ------------- > 56:46:32 <-- the minutes I'd like to get
From: Glenn on 25 May 2010 17:01 EAB1977 wrote: > If I want to find out how many minutes there are for times that I have > summed, I know I can use the hour function if the compiled time is > less than 24 hours. But, what if I want to get the times that are over > a 24 hour period, how do I do that? > > Example: > > 20:57:46 > 14:39:10 > 8:57:24 > 12:12:12 > ------------- > 56:46:32 <-- the minutes I'd like to get If your times above are in A1:A4, put this in A5: =SUM(A1:A4)*1440 Format the result as a number. That is assuming the answer you want is 3,406.53 minutes. Be more specific if that's not what you are looking for.
From: EAB1977 on 26 May 2010 08:40
Glenn, I think that'll work. Let me try it. |