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.
=IF(D2>H2,B2+1-D2,H2-D2)
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:
What is in cell B2?
Post a Comment