1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Microsoft excel problem

Discussion in 'General Programming Chat' started by bluhat, May 14, 2011.

  1. bluhat

    bluhat Jr. VIP Jr. VIP Premium Member

    Apr 26, 2011
    Likes Received:
    Home Page:
    Hello friends,

    I think this not the right section about my question but I did not found the right section.
    However, I have a problem with excel. I need to convert time. For example I need to convert 1:10 hrs and its result is 1.17 hrs. Please help me out this problem.

    Please again i say this is Microsoft excel problem.
    I am waiting for your good tips.

    Last edited: May 14, 2011
  2. DebtFreeMe

    DebtFreeMe Regular Member

    Mar 14, 2010
    Likes Received:
    To be honest, there are a lot of other places on the internet that could handle this a lot better than here, also Google has a search function, that can give you answers to questions like this sometimes. But, this is basic depending on how much excel you understand, how you have your data set up, and if you understand excel commands.

    So if you have 1:10 in cell A1, then you could do this


    where A1 is a cell containing a time value.

    So, if A1= 1:10 it returns a value of 1.16667

    Or, you could do a whole lot of other things, not sure what you're after, so good luck...
    Last edited: May 14, 2011