Untitled
unknown
plain_text
2 years ago
145 B
4
Indexable
=IF(HOUR(J2) > 0, HOUR(J2) & " uur", "0 uur") & IF(HOUR(J2) > 0 AND MINUTE(J2) > 0, " & ", "") & IF(MINUTE(J2) > 0, MINUTE(J2) & " minuten", "")
Editor is loading...
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", "")