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.
What is in cell B2?
ReplyDelete