Working as a Systems Administrator for Small and Medium Companies
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.