|
|
#6
01-11-2016, 06:52 AM
|
|||
|
|||
I'm not clear on what you are trying to accomplish. Are A1 and A3 start times and A2 and A4 end times? If so, then there are only 4.25 hours worked.
Why does A5 have today's date, 8:15 am? I don't understand the logic that leads to it. 
|
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode