Results 1 to 5 of 5
Like Tree1Likes
  • 1 Post By johnmpl

Pasar hora como numero entero

This is a discussion on Pasar hora como numero entero within the Questions in Other Languages forums, part of the Question Forums category; Hola, alguien tiene alguna formula con al cual pueda pasar una hora a numero. Por ejemplo: 16:40 que pase a ...

  1. #1
    New Member
    Join Date
    Apr 2017
    Posts
    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
    599

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

    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
    180

    Default Re: Pasar hora como numero entero

    ‘Hola, a todos!

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

    ‘Bendiciones!
    Greg Truby likes this.

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

    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