Announcement

Collapse
No announcement yet.

Seperate Decimal & Whole Number

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Seperate Decimal & Whole Number



    How do I seperate 1.2 and 1.02 miutes from the same column into Minutes and Seconds Correctly.

    How do I get the first to seperate as (1) Min (20) Secs and the next to
    seperate to (1) Min (2) Secs

    I have 200,000 line of data in one column with times from .o1 mins to 1498.40 mins that I am doing this to. I need to convert it all back to seconds.


    Short and sweet I hope

    Gary

  • #2
    Re: Seperate Time Correctly

    Times are NOT stored as decimals, so you don't have times, simply decimals.

    In B1
    =INT(A1)
    In C1
    =A1-B1

    Copy down via double click on the Fill Handle.

    Comment


    • #3
      Re: Seperate Decimal & Whole Number

      Hi Gary

      If you want to convert to seconds then maybe:

      =INT(A1)*60+MOD(A1,1)*100

      Richard

      Comment


      • #4
        Re: Seperate Decimal & Whole Number

        1.2 really means 1min 20s and not 1min 12s?
        Entia non sunt multiplicanda sine necessitate.

        Comment


        • #5


          Re: Seperate Decimal & Whole Number

          The formula I posted initially will do what you ask, although the resulting number will be a decimal representation of time rather than Excel time. If you want it in Excel time then:

          =INT(A2)/1440+MOD(A2,1)/864

          for A2 copied down.

          Richard

          Comment

          Working...
          X