=IF((COUNTIFS….FORMULA for TIME OVERLAP…ERROR 13 MISMATCH

Hi forum I'm needing some help I have a formula that calculate overlap time

Column A = Student Name
Column B = Time In
Column C = Time Out

Students sometimes sign in/out multiple times hence the reason for the time overlap formula

When I manually put in the formula and drag it down there’s no problem, but when I use my userform vba

ws.Cells(vNewRow, 6).Value =

Please Login or Register  to view this content.

I get run-time error '13': type mismatch

The data belonging to the other columns is still transferred but the formula is not transferred to column F

Thank You All

Hello vtnark,

The problem is with your syntax. When using quotes within a string, the quote must be enclosed in quotes. Here is the corrected code...

Please Login or Register  to view this content.

Hello vtnark,

You're welcome.