8 in 24 hours time formula

v1rt8v2 · #1 12-18-2015, 09:08 PM

Using date and time to be able to look back within 24 hours to see how many hours worked.
I.e.
Worked from yesterday 1200-1415 and then from 1530-1730. This would equal out to 4:15. If i am scheduled to work at 0800-1200 today, i would not be legal to start work until 0815 using a lookback formula.
A1 cell has start date and time
A2 cell has end date and time
A3 cell has start date and time
A4 cell has start date and time
Above are yesterdays

A5 would show the calc of when the legal time to start today.
Anybody have an idea. Thanks in advance

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate Average Time Elapsed in Days, hours and minutes	Nina46	Excel	9	09-11-2015 02:09 AM
Formula for decimal hours from two date time entries	DBenz	Excel Programming	0	01-15-2015 05:52 AM
Need a formula to calculate turnaround time in hours	ram_cl1981	Excel	5	09-29-2014 02:20 PM
Vba macro code for grouping the data based on 2 hours time	dharani suresh	Excel Programming	5	04-29-2014 03:25 AM
Date and time calcs excluding non-working hours	mrsatchmo	Excel	1	01-26-2011 08:50 AM