Untitled
=IF(HOUR(J2) > 0, HOUR(J2) & " uur", "0 uur") & IF(HOUR(J2) > 0 AND MINUTE(J2) > 0, " & ", "") & IF(MINUTE(J2) > 0, MINUTE(J2) & " minuten", "")
Leave a Comment
=IF(HOUR(J2) > 0, HOUR(J2) & " uur", "0 uur") & IF(HOUR(J2) > 0 AND MINUTE(J2) > 0, " & ", "") & IF(MINUTE(J2) > 0, MINUTE(J2) & " minuten", "")