View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JKLONEEAGLE JKLONEEAGLE is offline
external usenet poster
 
Posts: 5
Default 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