NUMBER TO TIME CONVERT - Page 4
NUMBER TO TIME CONVERT
Thanks Thanks:  0
Likes Likes:  0
Page 4 of 4 FirstFirst ... 234
Results 31 to 34 of 34

Thread: NUMBER TO TIME CONVERT

  1. #31
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,445
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Yogi,

    One more question, I promise.

    How can I format this to show only minutes i.e. :75

  2. #32
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-23 12:30, Brian from Maui wrote:
    Yogi,

    One more question, I promise.

    How can I format this to show only minutes i.e. :75
    Hi Brian:
    if we had the difference of A2 and B2 in cell C2 of 2.5 hours
    =(A2-B2)*24
    to get minuted, multiply further by 60
    =(A2-B2)*24*60
    =150 ... minutes

  3. #33
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,445
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yogi,

    Mahalo very much!!!

    Brian

  4. #34
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,579
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi Brian
    Sorry, I missed all the posts since mine
    so just for the record, I would have suggested:

    =LEFT(A1+1000,2)-10&":"&RIGHT(A1,2)

    Sure got plenty to choose from now!

    regards
    DereK

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com