60 to 100 min Clock

  • I am trying to enter data from a 60 minute clock with data such as 2.15.
    2= 2 Hours
    .15= 15 minutes
    I need this data as a 100 minute clock
    2= 2 Hours
    .25= 15 minutes


    If The data is entered as 2.15 then it is incorrect as excel is set at 100.
    So my question is how do I change it to except it in a 60 format?

    [SIZE=2]I should change my name to STUMBED![/SIZE]

  • Re: 60 to 100 min Clock


    Thanks,


    I spent so much time looking for the complex answer, I missed that one.
    Well appreciate it.

    [SIZE=2]I should change my name to STUMBED![/SIZE]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!