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)*24<br /><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.375"<br />E) MOD(RIGHT(A2,5)-LEFT(A2,5),1)*24 return 9<br /><br />right, left, mod,<br />
