Untitled

mail@pastecode.io avatar
unknown
plain_text
25 days ago
227 B
1
Indexable
Never
=IF(HOUR(J2) > 0, IF(HOUR(J2) = 1, HOUR(J2) & " uur", HOUR(J2) & " uren"), "0 uur") & IF(HOUR(J2) > 0 AND MINUTE(J2) > 0, " & ", "") & IF(MINUTE(J2) > 0, IF(MINUTE(J2) = 1, MINUTE(J2) & " minuut", MINUTE(J2) & " minuten"), "")
Leave a Comment