Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I need to display a duration that could last several month. I make a difference between 2 dates and I apply the format mm/dd/ hh:mm. It works fine except that it displays always 01 for the month. For axample 18/06/2009 23:03 22/06/2009 07:21 result = 01/03 08:17 where it should be 00/03 08:17 In fact Excel treat this duration as a serial date. In that case the minimun value for the month is 1 for January. Then the same problem is propagated in the chart that I make based on that column value. Any help is welcome Eric |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
duration | Excel Worksheet Functions | |||
How do I calculate duration entered in HH:MM-HH:MM format | Excel Discussion (Misc queries) | |||
format for duration | Excel Discussion (Misc queries) | |||
Format cell to show duration of phone calls | Excel Worksheet Functions | |||
Duration | Excel Discussion (Misc queries) |