Quote: BTW, I can't use military time to input the hours worked. that doesnt matter 23:00 is the same
as 11:00 pm just the cell format is different ,the underlying value is the same but 6.65 hours even according to your chart rounds to 6.7 as 0.65 hrs falls in between 39 and 45