100% yes... these are all time taken from an 8 hour shift.

The website i pull the data from is where the error occurs... only does this when employee works less than 1 hr... say he works 20 minutes, if i dont catch the mistake he gets paid for 20 hours

maybe could do something like (im kind of new to excel so i know im wrong on formula) =IF(>08:00:00)LEFT-3