How do I add a colon at the end of a cell in Excel - Excel Tips and Tricks

Here is a quick formula on how to calculate hours worked.

Use this formula.
=MOD(RIGHT(A2,5)-LEFT(A2,5),1)*24

Here is the break down of the formula.
Essentially, if your "Worked Times" cell value is this "8:00 - 17:00".
A) RIGHT(A2,5) return "17:00"
B) LEFT(A2,5) returns "08:00"
C) RIGHT(A2,5) - LEFT(A2,5) return "0.375"
D) MOD(RIGHT(A2,5) - LEFT(A2,5),1) return "0.375"
E) MOD(RIGHT(A2,5)-LEFT(A2,5),1)*24 return 9

right, left, mod,