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

LauraForiero

New member
Joined
Oct 8, 2013
Messages
3
Reaction score
0
Points
0
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












 

bgoree09

New member
Joined
Aug 20, 2013
Messages
179
Reaction score
0
Points
0
Good afternoon,

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

M6: =ROUND(K6*L6,2)

Hope this helps,
 

Hercules1946

New member
Joined
Mar 22, 2013
Messages
794
Reaction score
0
Points
0
Location
York, England
Excel Version(s)
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 ?
 
Top