Error Checking in Excel
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,450
    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,450
    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,584
    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

Some videos you may like

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
  •