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
LVL 103

Expert Comment

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

LVL 103

Expert Comment

by:Mike McCracken
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

LVL 33

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

Hope that's helpful.

EE Topic Advisor

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month