Forum Discussion

Dharmendra_Bharwad's avatar
Dharmendra_Bharwad
Brass Contributor
Mar 23, 2020
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...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Mar 23, 2020

    Dharmendra_Bharwad 

    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)))