Results 1 to 5 of 5

Thread: Pasar hora como numero entero

  1. #1

    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
    602

    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: http://www.mrexcel.com/forum/board-a...ml#post2545970
    Learn here how to install it: https://www.youtube.com/watch?v=Jycv...ature=youtu.be

  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,901

    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
    213

    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,901

    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.

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