Recording and Monitering Times

Originally Posted by mehmetcik

Try this instead:

Formula:

=IF(HOUR(E21)<12,HOUR(E21)*60+MINUTE(E21),1440-HOUR(E21)*60+MINUTE(E21))

Thank you for this im slightly confused by the E21 cell. I realize this is just an example but I can't seem to figure out the right way to apply it