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 |
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 |
All times are GMT +1. The time now is 06:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com