Results 1 to 4 of 4

Thread: Which functions to use?????***

  1. #1

    Which functions to use?????***



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I need to find the elapsed time and the amount due in this table??? help?

    G H I J K L M
    Start Date Start Time Stop Date Stop Time Elapsed time (calculated) Hourly Rate Amount due (Calculated)
    6 8/4/2013 12:59:00 8/6/2013 1:05:14 $18.27
    7 8/24/2013 9:00:00 8/28/2013 23:50:00 $10.79
    8 8/11/2013 9:29:40 8/11/2013 23:45:00 $10.51
    9 8/9/2013 10:33:36 8/10/2013 8:00:00 $10.77
    10 8/4/2013 8:45:00 8/5/2013 15:30:00 $13.01
    11 11/12/2013 9:10:00 11/16/2013 10:00:00 $14.50
    12 8/24/2013 12:47:31 8/24/2013 15:11:31 $10.37
    13 7/2013 15:30:00 7/8/2013 19:54:00 $12.99

  2. #2
    Good afternoon,

    K6: =((I6+J6)-(G6+H6))*24

    M6: =ROUND(K6*L6,2)

    Hope this helps,

  3. #3
    thank you so much
    Quote Originally Posted by bgoree09 View Post
    Good afternoon,

    K6: =((I6+J6)-(G6+H6))*24

    M6: =ROUND(K6*L6,2)

    Hope this helps,

  4. #4
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    772
    Articles
    0
    Excel Version
    2010
    Not wishing to complicate matters, but in your paid hours, is it OK to include the full 24 hours, as well as week-ends, and statutory holidays ?

Posting Permissions

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