Wednesday, September 17, 2008

Excel Time Difference Formula

Yeah, I know this is all round the great interweb but I don't care.  I want to post it here too so I KNOW where it is.  This blog is not just to help someone else after I found a solution.  I often come back here myself to find solutions I have used in the past.


D2 = Start Time
H2 = End Time

Yeah, it look complicated but it works wonderfully.  It doesn't take into account dates, so it only works from one day to the next if going over night.

1 comment:

jopet said...

What is in cell B2?