Home>


Get data from CSV and insert into cell.
Display the difference after calculating hours and minutes with the Time function.
When it exceeds 0:00, the time display will be an error and it will not work.

=IF(A2="","",TIME(G2,J2,)-TIME(A2,D2,))

If there is another more efficient method, please ask me.

  • Answer # 1

    It's hard work, but what about the following?

    =IF(A2="","",IF(TIME(G2,J2,)>=TIME(A2,D2,),TIME(G2,J2,)-TIME(A2,D2,),1+TIME( G2,J2,)-TIME(A2,D2,)))