Search This Blog

Sunday 17 August 2014

CALCULATE SHIFT HOURS FROM SHIFT WINDOW (START TIME AND END TIME)



Say, you are given shift timings ( shift start time and shift end time) and you need to calculate shift hours from them. Below is the formula for that.

Formula in B2:
=MOD(RIGHT(A2,5)-LEFT(A2,5),1)*24 and drag it down.