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...
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)))
Better to have sample file, not the image. That could be like =I17-I16 with applied format as [hh]:mm
- Yes agreed but I specifically need difference
of time between I16 and I17 cells.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)))