Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 9th 08, 08:28 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default 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




  #2   Report Post  
Old January 9th 08, 07:34 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
Posts: 5
Default 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







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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


All times are GMT +1. The time now is 09:27 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017