Yep - done that - made sure all the cells are hh:mm.
Just done a bit of mucking about
:
Quote:
=IF(ISBLANK(E10),"None",IF((TIMEVALUE("7:30 AM")-E10)<0,0,TIMEVALUE("7:30 AM")-E10)+IF((F10-TIMEVALUE("18:30"))<0,0,F10-TIMEVALUE("18:30")))
|
...works a treat!
Thanks to everybody who helped in the formula!