+ Reply to Thread
Results 1 to 3 of 3

change the format of the minute

  1. #1
    Registered User
    Join Date
    05-15-2008
    Posts
    38

    change the format of the minute

    Hello,
    Richard Buttrey kindly propose me yesterday to use the next formula:

    =HOUR(B2)&MINUTE(B2)&SECOND(B2)&IF(SECOND(B2)=0,0,"")

    to change the format from
    5:39:00
    to
    53900

    The problem is that when the time is between 5:00:00 to 5:09:00, the “00” transforms in “0”, and the "09", just in "9":
    5000, 5900.

    How could I make to obtain the first zero, like in “50900”?

    Thanks

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    Try

    =TEXT(B2,"hmmss")

  3. #3
    Registered User
    Join Date
    05-15-2008
    Posts
    38

    Thank you

    Thank you very much, Daddylonglegs,
    that was what I need.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1