I've been using with success the following formula to calculate the difference between two cells
=TEXT(D2-C2,"h:mm:ss")
This works if the two cells are formatted like
02/09/2013 07:00 - 02/09/2013 19:00
However this formula does not work if the cells are
mon 02/09/2013 07:00 - mon 02/09/2013 19:00
I extract a mass amount of data like this, is there a formula for this?
thx in advance
Bookmarks