Im trying to input a time in C6 and get a different time in another cell
EXAMPLE::
=IF(AND(C6=TIMEVALUE("08:00:00")),TIMEVALUE("16:00:00"),IF(AND(C6=TIMEVALUE("08:00:00")),TIMEVALUE("16:00:00"),0.327,IF(C6=TIMEVALUE("08:00:00")),TIMEVALUE("16:00:00")))
Aucun commentaire:
Enregistrer un commentaire