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 103

Comment

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

mlmcc
1
LVL 103

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

mlmcc
0

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month