1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Simple excel function question

Discussion in 'Business Applications' started by DieRiding, Apr 20, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. DieRiding

    DieRiding Thread Starter

    Joined:
    Oct 26, 2005
    Messages:
    28
    Hi,

    Is there a way to get excel to convert a time to a decimal? I want 6:45 to return 6.75 or 6:30 to return 6.5
    If it helps, here's my situation:

    I'm a waiter trying to learn excel. Thought it would be nice to use it to track my working habits and wages. I'm trying to enter tips received(C), time in(E), time out(F), and then I want to use functions to give me how many hours I worked, and what my total pay was, and my hourly.

    So in (I) I've put the function =E-F to get the total hours I worked, but I can't figure out how to convert the hours to a decimal so I can use them in math functions.
    Here's an example,
    In at 4:30 out at 11:15. e-f returns 6:15. I want to take that and multiply it by minimum wage. but to do that I need 6:15 to be 6.25.

    Thanks for any help.
     
  2. maxflia10

    maxflia10

    Joined:
    Feb 24, 2003
    Messages:
    331
    Multiply by 24 and format as a number....;)
     
  3. DieRiding

    DieRiding Thread Starter

    Joined:
    Oct 26, 2005
    Messages:
    28
    I may in fact, be retarded.

    I have no idea what you mean by multiplying by 24, but it just occurred to me that I could just put the times in as decimal points in the first place and not have any problems.

    Thanks for the kick in the *** to figure it out.
     
  4. The Villan

    The Villan

    Joined:
    Feb 20, 2006
    Messages:
    2,255
    Open up the attachment and look at the yellow cells which are formulas.
    I think this is what you want.

    Excel bases time on a 24 hour clock.
    This wont work if say for example you are working from 11pm to say 6 am.
    However it sounds like you are working during the day and don't work more than 24 hours at a time and don't work past midnight. Is that correct?
    You can input the time as 6:33 not as a fraction. The formula looks after the fraction.

    I hope I have it right for you. Come back if it isn't what you want.
     

    Attached Files:

  5. The Villan

    The Villan

    Joined:
    Feb 20, 2006
    Messages:
    2,255
    Seems like we crossed maxflia10 :)
     
  6. DieRiding

    DieRiding Thread Starter

    Joined:
    Oct 26, 2005
    Messages:
    28
    That works better than what I was doing, millitary time makes more sense too. Only issue is I do work past midnight some nights. Any advice on how to handle that one?
     
  7. The Villan

    The Villan

    Joined:
    Feb 20, 2006
    Messages:
    2,255
    break the time up so that you have 2 lines e.g.
    23:00 24:00
    00:00 8:00
     
  8. maxflia10

    maxflia10

    Joined:
    Feb 24, 2003
    Messages:
    331
    For times running into the next day, try,

    =MOD(B1-A1,1)*24

    Where A1 is start time, B1 end time.
     
  9. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/705554

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice