From: EAB1977 on
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
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
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
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
Glenn,

I think that'll work. Let me try it.