View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
abadd0n abadd0n is offline
external usenet poster
 
Posts: 11
Default Create clock in excel

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?