Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Custom Cell Formats

  1. #1
    Join Date
    20th January 2007
    Location
    Scotland
    Posts
    4

    Custom Cell Formats

    Hi

    I would like to display the following number of hours as day hour minute format
    48.0 hrs as 2d 00h 00m.
    i have seen this format before but did not note it can anyone help?

    Martin

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,313

    Re: Custom Cell Formats

    Try,

    d"d" hh"h" mm"m"

    Cheers
    Andy


  3. #3
    Join Date
    20th January 2007
    Location
    Scotland
    Posts
    4

    Re: Custom Cell Formats

    thats great but how do i get the m for the minutes behind the number
    it looks like 1d 0h m0

    Martin

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: Custom Cell Formats

    Works for me, check where you have put the double quotes.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    20th January 2007
    Location
    Scotland
    Posts
    4

    Re: Custom Cell Formats

    Great sorted that one!!

    Many Thanks
    Martin

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Custom Formats
    By pukks in forum EXCEL HELP
    Replies: 3
    Last Post: February 20th, 2007, 20:31
  2. Custom Formats
    By Dave Hawley in forum Excel FAQ
    Replies: 0
    Last Post: October 19th, 2005, 16:12
  3. Custom Formats
    By Dave Hawley in forum OPEN SOURCE: Hey! That is Cool!
    Replies: 0
    Last Post: February 24th, 2003, 14:36

Bookmarks

Posting Permissions

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