Excel now() Function

[colin]

I am trying to produce a time sheet program such that when I enter the
letter 'x' in a specific cell I can record that time as my start time
in an adjacent cell. Then by inserting an 'X' in the next cell I can
record my finish time and so on. I can capture the time with an "if
(now())" formula but of course every time I enter the next time my
first gets recalculated. Can any one suggest a way of retaining the
times when it was entered, Microsoft were unable to help.

 

[jpdphd]

A Google search for "excel timesheet" produced this hit

http://www.vertex42.com/ExcelTemplates/free-timesheet-template.html

From it, I learned that command-shift-; inserts the current time into

the selected cell. The now() function is not needed, nor is a macro.

 

[Jim Gordon MVP]

Hi Colin,

This is one of those times that using a Macro or an AppleScript will come in
handy.

Have you done anything with either in the past? Are you ready to dive in?

-Jim Gordon
Mac MVP

I am trying to produce a time sheet program such that when I enter the
letter 'x' in a specific cell I can record that time as my start time
in an adjacent cell. Then by inserting an 'X' in the next cell I can
record my finish time and so on. I can capture the time with an "if
(now())" formula but of course every time I enter the next time my
first gets recalculated. Can any one suggest a way of retaining the
times when it was entered, Microsoft were unable to help.

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info