| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AUTO FILL CELL WITH DATE & TIME OF DAY AM/PM
HELP.
I WANT THE CELLS IN COLUMN "A1 THRU A34" TO BE AUTOMATICALLY FILLED IN WITH THE DAYS DATE & CURRENT TIME A.M./P.M. WHEN I POPULATE AN OPPOSING CELL IN COLUMN "B1 THRU B34" AND I DO NOT WANT THE TIME & DATE TO CHANGE WHEN I REOPEN THE SPREADSHEET. I ALSO WANT THE TIME OF DAY IN COLUMN "C1 THRU C34 TO BE SUBSTRACTED FROM THE TIME OF DAY SHOWN IN COLUMN "D1 THRU D34. IS THIS POSSIBLE IN EXCEL AND HOW WOULD THIS BE DONE. YOUR HELP WILL BE VERY MUCH APPRECIATED. HELP!!!!!!! THANK YOU. REGARDS, JKLONEEAGLE |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make excel auto fill in date and current time | Excel Discussion (Misc queries) | |||
| auto fill current time | Excel Discussion (Misc queries) | |||
| Auto insert Date & Time when another cell is populated | Excel Discussion (Misc queries) | |||
| Auto date/time insert when data entered into an adjacent cell | Excel Worksheet Functions | |||
| Auto Date/Time when click on cell | Excel Programming | |||
Threaded Mode
