Create clock in excel

A

abadd0n

Hi,

I have a shared sheet in office where my team members put in start and end
time of different activities performed by them on daily basis.

Now the problem is the time put by them is different for each individual. I
am looking for a validation where they have to follow same format across the
sheet.

dd/mm/yy HH:MM

Is it possible using validation? or any other way anyone can suggest?
 
L

Luke M

you could format the cells to display the way you want
Custom format:
dd/mm/yy hh:mm

Combined with placing Data->Validation
of must enter a date greater than say, 1/1/2000?
 
A

abadd0n

Thanks Luke,

But the only problem is my team members are smart enough to paste value on
the cell. I tried it before, however, it is not fool proof. :(

Any other suggestions apart from resolving their attitude issues :p
 
B

Bill Sharpe

abadd0n said:
Thanks Luke,

But the only problem is my team members are smart enough to paste value on
the cell. I tried it before, however, it is not fool proof. :(

Any other suggestions apart from resolving their attitude issues :p
Click to expand...
"Do it my way or you're fired!" can resolve a lot of attitude issues,
but many companies still use actual time clocks that must be "punched."

Bill
 
Top