Totals in Days, Hrs and Minutes

247.00
5.00
125.00
640.00
535.00
610.00
186.00
785.00
265.00
380.00
554.00
1,355.00

I need the above column (those values are in minute
values) to total 3 days, 22 hours and 32 minutes.

Any ideas? Please, your assistance is appreciated.

Thanks,

Syd

Have a look at http://cpearson.com/excel/datetime.htm#AddingTimes

Basically, you need to add up the minutes and divide the total by 1440
(24hours x 60 minutes). If you format the result as time (d h:mm) you should
get what you require.

Andy.

"Syd" wrote in message
...
247.00
5.00
125.00
640.00
535.00
610.00
186.00
785.00
265.00
380.00
554.00
1,355.00

I need the above column (those values are in minute
values) to total 3 days, 22 hours and 32 minutes.

Any ideas? Please, your assistance is appreciated.

Thanks,

If you want a numeric value you need to sum then and divide by 1440 (number
of minutes per day)

=SUM(A1:A12)/1440

now use a custom format such as

dd hh:mm

doing so I get 3 day, 22 hours and 47 minutes

if you want it in one fell swoop you could use this formula

=TEXT(SUM(A1:A12)/1440,"dd hh:mm")

note that the latter is a text value

--

Regards,

Peo Sjoblom


"Syd" wrote in message
...
247.00
5.00
125.00
640.00
535.00
610.00
186.00
785.00
265.00
380.00
554.00
1,355.00

I need the above column (those values are in minute
values) to total 3 days, 22 hours and 32 minutes.

Any ideas? Please, your assistance is appreciated.

Thanks,

Thanks Peo


-----Original Message-----
If you want a numeric value you need to sum then and
divide by 1440 (number
of minutes per day)

=SUM(A1:A12)/1440

now use a custom format such as

dd hh:mm

doing so I get 3 day, 22 hours and 47 minutes

if you want it in one fell swoop you could use this
formula

=TEXT(SUM(A1:A12)/1440,"dd hh:mm")

note that the latter is a text value

--

Regards,

Peo Sjoblom


"Syd" wrote in message
...
247.00
5.00
125.00
640.00
535.00
610.00
186.00
785.00
265.00
380.00
554.00
1,355.00

I need the above column (those values are in minute
values) to total 3 days, 22 hours and 32 minutes.

Any ideas? Please, your assistance is appreciated.

Thanks,




.

Hi Syd,

It works until your total days does not exceed 31.
Let us know if that possibility exists.

Regards,

Daniel M.


"Syd" wrote in message ...
Thanks Peo


-----Original Message-----

=SUM(A1:A12)/1440

now use a custom format such as

dd hh:mm

Note that this only works in the 1900 date system and for total days
not exceeding 31.

To correct for the 1904 system, subtract 1 from the result.

In article ,
"Peo Sjoblom" wrote:

If you want a numeric value you need to sum then and divide by 1440 (number
of minutes per day)

=SUM(A1:A12)/1440

now use a custom format such as

dd hh:mm

doing so I get 3 day, 22 hours and 47 minutes

if you want it in one fell swoop you could use this formula

=TEXT(SUM(A1:A12)/1440,"dd hh:mm")

note that the latter is a text value

Daniel:

Yes, they will exceed 31 days. Any solutions or work
arounds to this?


-----Original Message-----
Hi Syd,

It works until your total days does not exceed 31.
Let us know if that possibility exists.

Regards,

Daniel M.


"Syd" wrote in message news:02d401c37c76
...
Thanks Peo


-----Original Message-----

=SUM(A1:A12)/1440

now use a custom format such as

dd hh:mm



.

On Tue, 16 Sep 2003 19:22:42 -0700, "Syd" wrote:

Yes, they will exceed 31 days. Any solutions or work
arounds to this?


=INT(sum/1440)& " days " & TEXT(MOD(sum/1440,1),"h:mm")

or

=INT(sum/1440)&" days "&TEXT(MOD(sum/1440,1),"h"" hrs ""m"" min""")

The results are text.


--ron