Hi Terry,
Am Mon, 07 Sep 2015 08:31:41 +0100 schrieb Terry Pinnell:
Using Excel 2000 I'm now trying to calculate the time gap between
several hundred of these, as shown he
https://dl.dropboxusercontent.com/u/...Formulas-1.jpg
in B2 try:
=TIME(MID(A2,FIND("-",A2)+1,2),MID(A2,FIND("-",A2)+3,2),MID(A2,FIND("-",A2)+5,2))
and copy down
in C3 try:
=B3-B2
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional