Hey guys,

Quite a newbie here so please bear with me. The issue is rather simple but it seems that despite the amount of searching I have done I'm unable to find a simple fix. I am creating an employee time sheet that takes in clock in/clock out time in two separate cells, then subtracts the two and returns a number of hours worked. This is all fine as long as AM and PM are specified in each cell, but when a user omits this rule or does not write the time in military format, I am left with a negative value (Ex. 9:00 and 5:00 would produce -4). I've attempted to write a macro that adds 12 to any negative value in my "hours worked" column but have been unsuccessful. I have very little programming experience and don't remember VB too well. Is there a simple solution I am missing? And if not, could someone please point me in the right direction on how to create this script? Thank you in advance.