Forum Discussion
Solved
Difference of time
Hi,
I want to have total time worked by my employees. The cell E15 refers to formula wherein I want to derive total time worked by my employee as a difference between I17 and I16. I have attached herewith my sample sheet.
Thanks.
That could be
=(DATE(MID(I17,SEARCH(",",I17)-4,4),MONTH(1&LEFT(I17,SEARCH(" ",I17)-1)),MID(I17,SEARCH(" ",I17)+1,2))+TIMEVALUE(RIGHT(I17,LEN(I17)-SEARCH(",",I17)-1)))- (DATE(MID(I16,SEARCH(",",I16)-4,4),MONTH(1&LEFT(I16,SEARCH(" ",I16)-1)),MID(I16,SEARCH(" ",I16)+1,2))+TIMEVALUE(RIGHT(I16,LEN(I16)-SEARCH(",",I16)-1)))
9 Replies
- Hello,
The formula will be
=TEXT(E17-E16,"h:mm")
=17:00 Better to have sample file, not the image. That could be like =I17-I16 with applied format as [hh]:mm
