| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Format cells to display minutes difference
D-DAY TODAY
04/01/2008 05/14/2007 322 days 9 hrs 23.0 min 24 sec 0\days [h]\hrs m.0\min ss\sec in the above worksheet, I calculate the difference betweeen two dates. I have formatted the cells to display only days, hours,& seconds successfully. I am having problems with the minutes format, everytime I take the decimal part out, it revervts to 1 min regardless of the actual value. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format cells in degrees & minutes of arc. | Excel Discussion (Misc queries) | |||
| Format Cells to calculate hours and minutes taken to complete task | Excel Worksheet Functions | |||
| how do i format cells in excel to show difference in payment amt | Excel Discussion (Misc queries) | |||
| Display minutes ONLY and calc difference | Excel Discussion (Misc queries) | |||
| how do I format a cell to display in degrees minutes seconds | Excel Worksheet Functions | |||
Threaded Mode
