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 Marketplace seller Premium Member

    Joined:
    Apr 26, 2011
    Messages:
    1,131
    Likes Received:
    143
    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.

    Thanks
     
    Last edited: May 14, 2011
  2. DebtFreeMe

    DebtFreeMe Regular Member

    Joined:
    Mar 14, 2010
    Messages:
    418
    Likes Received:
    363
    Occupation:
    Military
    Location:
    Earth
    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

    =(A1-INT(A1))*24

    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