|
| 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
January 9th 08, 08:28 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting cells to show length of time in Days and hours
You could do something like =INT(A2)&" days "&TEXT(A2,"hh")&" hours"
-- David Biddulph "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 > 
|
| Ads |
|
#2
January 9th 08, 07:34 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting cells to show length of time in Days and hours
Many thanks David - it worked a treat!
Kenny "David Biddulph" <groups [at] biddulph.org.uk> wrote in message ... > You could do something like =INT(A2)&" days "&TEXT(A2,"hh")&" hours" > -- > David Biddulph > > "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 >> > >
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| calculate time in days:hours:minutes | Stice | Excel Discussion (Misc queries) | 1 | February 5th 07 09:55 PM |
| When I add time - Example 10 days of 8 hours each I receive 81.46 | Kathy | Excel Worksheet Functions | 3 | August 12th 06 05:43 PM |
| Subtract time between certain days/work hours? | lisa b. | Excel Worksheet Functions | 2 | July 17th 06 09:26 PM |
| How to convert an elapsed time in minutes to Days hours and minute | Time Tracker | Excel Discussion (Misc queries) | 1 | April 9th 06 03:40 AM |
| How to show negative time (e.g. -10 hours) | Arhippa | Excel Worksheet Functions | 3 | January 19th 05 08:53 AM |
Linear Mode
