If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hour function equivelent help
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 |
#2
|
|||
|
|||
Hour function equivelent help
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 |
#3
|
|||
|
|||
Hour function equivelent help
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" wrote in message ... 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 |
#4
|
|||
|
|||
Hour function equivelent help
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. |
#5
|
|||
|
|||
Hour function equivelent help
Glenn,
I think that'll work. Let me try it. |
Thread Tools | |
Display Modes | |
|
|