I'm trying to have two cells, so I when I enter midnight (or 0:00) in the first cell I get 8am ( or 8:00) in the second cell. But if I put 8am in the first cell I get 4pm in the second cell. As well as if I put 4pm in the first cell I get midnight in the second cell.
This is the if statement I came up with::
=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")))
I tried the first IF without the AND (only) getting it to work but that is it