Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting cells to show length of time in Days and hours
Have you read a book on how Excel keeps days and times. I'll be glad to
charge you $150. to answer your question. You can have the answer for the price of a $4 0 book. tyro "Forum Freak" wrote in message ... Hi all Is it possible to format cells to show length of time as "Days and Hours"? I tried [d]:h (based on [h]:m) but this does not work. d:h gives a false result if the value is a few months! The majority of cells time value are around a couple of days but occasionally some values are months or even over a year. I do not want to format as "y:m:d:h" to cover every eventuality. I am using excel2003 TIA Kenny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells to show length of time in Days and hours | Excel Discussion (Misc queries) | |||
calculate time in days:hours:minutes | Excel Discussion (Misc queries) | |||
When I add time - Example 10 days of 8 hours each I receive 81.46 | Excel Worksheet Functions | |||
Subtract time between certain days/work hours? | Excel Worksheet Functions | |||
How to convert an elapsed time in minutes to Days hours and minute | Excel Discussion (Misc queries) |