View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
newbie_010108 newbie_010108 is offline
external usenet poster
 
Posts: 19
Default Time and Date populates automatically

Hi,
how can i make col m autopopulates with a date and time whenever col k is
populated with info and col N populates date and time whenever col L has an
info. Col O will compute for the time lapse between col m and n. on the 2nd
tab, will be the employee # of working hours summary.
1st tab detail:
Col K - Employees name
Col L - Work Status
Col M - Time Started
Col N- End Work
Col O - Time Lapse