LinkBack URL
About LinkBacks
can you post a sample spreadsheet - are you only comparing the cell below each time
in which case you could use in cell F6
=IF(D7>D6+TIME(0,3,0),D6,"")
In H6
=IF(F6<>"",D7-D6,"")
in J6
then you can sum column H
see attached
can you post a sample spreadsheet - are you only comparing the cell below each time
in which case you could use in cell F6
=IF(D7>D6+TIME(0,3,0),D6,"")
In H6
=IF(F6<>"",D7-D6,"")
in J6
then you can sum column H
see attached
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks