Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Kingwood, Texas, USA
    Posts
    112
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formatting Time Difference (2003)

    I have a column of cells that calculate the difference in time in hours and minutes ([h]:mm). I would like to change this to fractional days so I divided each formula by 24 and that almost gave me what I wanted. The days are in the format X.YZ; I would like them to round to X.Y. Is there a simple way to do this that I am overlooking? Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formatting Time Difference (2003)

    If you want fractional days, you should not divide by 24, since Excel already stores times as fractions of a day. Instead, select the cells, then select Format | Cells... In the Number tab, change the number format from a Time format to a Number format with 1 decimal place.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Kingwood, Texas, USA
    Posts
    112
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting Time Difference (2003)

    Thanks. I believe I need to go back to formatting 101 after my question. <g>

    Got myself into tunnel vision because of previous need (addressed here) about calculating time differences between dates/time of day.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •