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?

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?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"abadd0n" wrote:

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?

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

"Luke M" wrote:

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?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"abadd0n" wrote:

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?

abadd0n wrote:
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

"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