Untitled

 avatar
unknown
plain_text
a year ago
227 B
2
Indexable
=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