Last but not least the formula is not working when the activity happens within the same day. So if you put in the appropriate cells that something arrived 2/3/14 11:16 and then unloaded 2/3/14 23:16 then it shows 1.50 but should be 0.50. This is the same for any activity within the same day. I definitely appreciate your help Kaper!!!!