| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I automatically enter a time and date? | Excel Discussion (Misc queries) | |||
| Type data in one cell - and it automatically populates another cel | Excel Worksheet Functions | |||
| DATE & TIME OF DAY APPEAR AUTOMATICALLY IN CELL | Excel Discussion (Misc queries) | |||
| date and time updated automatically | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Threaded Mode
