Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Pasar hora como numero entero

  1. #1
    New Member
    Join Date
    Apr 2017
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Pasar hora como numero entero

    Hola,
    alguien tiene alguna formula con al cual pueda pasar una hora a numero.

    Por ejemplo:

    16:40 que pase a 1640
    12:10 que pase a 1210.

    Quedo atento a sus comentarios.

  2. #2
    Board Regular Trouttrap2's Avatar
    Join Date
    May 2010
    Location
    California
    Posts
    605
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pasar hora como numero entero

    Try
    =ROUND(INT(A3*24)&MOD(A3*24,1)*60,0)

    Instead:
    =ROUND(INT(A3*24)&TEXT(ROUND(MOD(A3*24,1)*60,0),"00"),0)
    Last edited by Trouttrap2; Apr 27th, 2017 at 06:48 PM.
    Using Excel 2010.
    Want to copy and post your example? Get the HTML Maker here:https://www.mrexcel.com/forum/about-board/1017050-mrexcel-html-maker-update.html


  3. #3
    MrExcel MVP
    Int'l Moderator
    Greg Truby's Avatar
    Join Date
    Jun 2002
    Location
    39° 17' 15" N, -94° 40' 26" W
    Posts
    9,955
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Pasar hora como numero entero

    =hour(a1) * 100 + minute(a1)
    Greg
    ………………………………………………
    Home: XL 2003, 2007, 2010, and 2013 on Windows 7
    Work: XL 2013, 2016 on Windows 10
    Please use CODE tags - especially for longer excerpts of code.

  4. #4
    Board Regular
    Join Date
    Jun 2013
    Posts
    227
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pasar hora como numero entero

    ‘Hola, a todos!

    Otra opciσn podrνa ser:
    =--TEXTO(A1;"hmm")

    ‘Bendiciones!

  5. #5
    MrExcel MVP
    Int'l Moderator
    Greg Truby's Avatar
    Join Date
    Jun 2002
    Location
    39° 17' 15" N, -94° 40' 26" W
    Posts
    9,955
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Thumbs up Re: Pasar hora como numero entero

    Quote Originally Posted by johnmpl View Post
    =--TEXTO(A1;"hmm")
    ‘Eso!
    Greg
    ………………………………………………
    Home: XL 2003, 2007, 2010, and 2013 on Windows 7
    Work: XL 2013, 2016 on Windows 10
    Please use CODE tags - especially for longer excerpts of code.

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