Here is a quick formula on how to calculate hours worked.br br Use this formula.br =MOD(RIGHT(A2,5)-LEFT(A2,5),1)*24br br Here is the break down of the formula.br Essentially, if your "Worked Times" cell value is this "8:00 - 17:00".br A) RIGHT(A2,5) return "17:00"br B) LEFT(A2,5) returns "08:00"br C) RIGHT(A2,5) - LEFT(A2,5) return "0.375"br D) MOD(RIGHT(A2,5) - LEFT(A2,5),1) return "0.