Shift Status Calculator

Hi,

I am stuck in managing a sheet using "TIME". IT is taking a lot of time .. sigh..

here goes.

timecalculator.xlsx

If you see the attachment, I am looking at sheet which helps me in know how many people are still working and how many have their shift gettingover.

Further, for the one's who are still at work... how much time is left for them

This is something I would like to on hourly basis.

The value in column "D" is what I am looking at. I entered a dummy data for help.

I would be entering on ly the Start Time and the end time. Rest should populate automatically.

Any luck anyone??

I have changed the format and benchmark time

HTH