Hi,

Can someone help me with a sheet which will show start time and end time in seconds. I mean when I enter Shift+Ctrl semicolon will give me the time(hh:mm) and after few seconds if enter the same it gives me same format time(hh:mm). I am manually changing the format into MM:SS. Simple I need a spread sheet where I can capture start and end time accurately.

I have a team who work on a task by time based, every second counts.

2nd Question- I want the time format uneditable, it should not allow me to make the changes on the time entered.