Hi All,
Looking for a formula to lookback 24 calendar hours and extract the hours and minutes within the start to end periods.
A B C
Start End 24 hr lookback
10/24/13 12:00 10/24/13 13:20 1:20
10/24/13 18:00 10/24/13 19:10 sum of time within 24 hours of C3 = 2:30 or 2.5
10/24/13 19:40 10/24/13 20:40 Sum of time within 24 hours of C4 = 3:30 or 3.5
10/25/13 12:40 10/25/13 13:40 Sum of time within 24 hours of C5 = 4:10 or 4.2
Bookmarks