Try this in D1:
=IF(A1<>A2,"",TIMEVALUE(LEFT(B2,LEN(B2)-2))-TIMEVALUE(LEFT(C1,LEN(C1)-2)))
Copy down
Try this in D1:
=IF(A1<>A2,"",TIMEVALUE(LEFT(B2,LEN(B2)-2))-TIMEVALUE(LEFT(C1,LEN(C1)-2)))
Copy down
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks