convert hours and minutes into days
 

I have a formula in a cell that adds up a bunch of hours and minutes and is
in the [h]:mm format, it gives me a total of 48:00

How do I get display that information, in another cell, and give me how many
days that is like, which would be 2 days

convert hours and minutes into days
 

One way:

XL stores times as fractional days, so multiply by 24 hrs/day:

A1: =SUM(....) <==== 48:00
A2: =A1*24 <==== 2

Format A2 as General, or your preferred Number format.

In article ,
Joshua wrote:

I have a formula in a cell that adds up a bunch of hours and minutes and is
in the [h]:mm format, it gives me a total of 48:00

How do I get display that information, in another cell, and give me how many
days that is like, which would be 2 days

convert hours and minutes into days
 

Simply change the format to include the days, as in:
d hh:mm
or, just:
d

Regards,
Fred.

"Joshua" wrote in message
...
I have a formula in a cell that adds up a bunch of hours and minutes and is
in the [h]:mm format, it gives me a total of 48:00

How do I get display that information, in another cell, and give me how
many
days that is like, which would be 2 days

convert hours and minutes into days
 

Just a caution -

That will work for sums less than 32 days, and only if your users are
guaranteed to only use the 1900 Date system.

The "d" format refers to the "day of the month".

In the 1900 system, the base date is 31 December 1899, so 1.000...
refers to 1 January 1900.

However, if your user is using the 1904 date system the base date is 1
January 1904, and 1.000.... is interpreted as 2 January 1904, so your
results will appear to be off by 1 day.

And of course, in either system, values greater than 31 will roll over
to February, etc.


In article ,
"Fred Smith" wrote:

Simply change the format to include the days, as in:
d hh:mm
or, just:
d

convert hours and minutes into days
 

Format as General or Number.
--
David Biddulph

Joshua wrote:
I have a formula in a cell that adds up a bunch of hours and minutes
and is in the [h]:mm format, it gives me a total of 48:00

How do I get display that information, in another cell, and give me
how many days that is like, which would be 2 days