convert hours and minutes into days

  • Thread starter Thread starter Joshua
  • Start date Start date
J

Joshua

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
 
Simply change the format to include the days, as in:
d hh:mm
or, just:
d

Regards,
Fred.
 
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.
 
Back
Top