+ Reply to Thread
Results 1 to 4 of 4

figuring time and converting to units

  1. #1
    Registered User
    Join Date
    05-23-2005
    Posts
    3

    Question figuring time and converting to units

    I need to add time and convert it to units. An example is

    If someone works from 7:15 to 11:30 I need the total to read 4.25 and it reads 4.15,

    We have clients that work for us and we bill another agency based on whole and quarter hours (.25, .50, .75) I have tried everything I can think of and cannot figure out a formula. When I think I have it, it comes up in time

    Thanks in advance

  2. #2
    Registered User
    Join Date
    05-23-2005
    Location
    Portland, OR
    Posts
    3
    If J3 contains the time version, 4:15:

    =HOUR(J3)+MINUTE(J3)/60
    and make sure this cell is formatted as number, not time

    If you want the calculation to be done at the same time, replace J3 in the formula to whatever cells you're calculating from, such as:

    =HOUR(J3-J1)+MINUTE(J3-J1)/60

  3. #3
    Registered User
    Join Date
    05-23-2005
    Posts
    3

    It didnt work

    This is what I get when I put that formula in

    Time In 7:30
    Time Out 10:45
    Service Units 6:00

    I need the formula to read 3.25 for the amount of hours worked

  4. #4
    Registered User
    Join Date
    05-23-2005
    Posts
    3

    Thumbs up I finally got it to work

    I needed to format the cells differently

    Thank you thank you!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1