|
| 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
June 12th, 2009, 08:19 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 
|
|
#2
June 12th, 2009, 08:46 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#3
June 12th, 2009, 10:20 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#4
June 13th, 2009, 04:33 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#5
June 14th, 2009, 11:22 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
