need help

looking for help on a formula that will calculate the total Time off clock. what is the total time between clock out and clock in per day

                      ---Clock In---            ---Clock Out---                                                        
Clock In Date            Actual               Actual                                    
                                                                                    
                                                                        
08/14/17            7:13 AM            12:01 PM            
08/14/17            12:31 PM      3:29 PM      

thanks in advance for any assistance
0
LVL 101

Expert Comment

by:mlmcc
This really should be a question rather than a POST.

mlmcc
1
LVL 6

Expert Comment

by:Doug Walton
0
LVL 101

Expert Comment

by:mlmcc
WHat have you tried thus far?

I suspect the issue is because you need data from 2 records.
You can loo at fields from the Previous and Next records

mlmcc
0
LVL 19

Administrative Comment

by:Andrew Leniart
Hi Kevin,

Welcome to Experts Exchange.

What you have done is made a "Post" here.  To get expert help, you need to "Ask a Question" so that more experts are able to see that you need help. Click the Big blue button near the top of your screen.

Ask a Question

The following link also explains more about asking for help at Experts Exchange...
http://support.experts-exchange.com/customer/portal/articles/336330

Hope that's helpful.

Regards,
Andrew
EE Topic Advisor
0

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month