Announcement

Collapse
No announcement yet.

Custom Cell Formats

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    Re: Custom Cell Formats

    Try,

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

    Cheers
    Andy

    Comment


    • #3
      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

      Comment


      • #4
        Re: Custom Cell Formats

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

        Comment


        • #5


          Re: Custom Cell Formats

          Great sorted that one!!

          Many Thanks
          Martin

          Comment

          Working...
          X