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

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

Please take the opportunity to connect and share this video with your friends and family if you find it useful.