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

1. ## Which functions to use?????***

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. Good afternoon,

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

M6: =ROUND(K6*L6,2)

Hope this helps,

3. thank you so much
Originally Posted by bgoree09
Good afternoon,

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

M6: =ROUND(K6*L6,2)

Hope this helps,

4. 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
•