Formula requireing the system time

M

Major Tomm

I am trying to create a formula that would add the current timefrom my
computer to a given cell if the an other given cell is greater then 0
 
J

JE McGimpsey

one way:

Assume: "given cell" is A1

=IF(A1>0,A1 + MOD(NOW(),1),"")

Format as time if necessary.
 
M

Major Tomm

This really didn't do it.
Hers an example of what I need,
If E785 is greater then 0, I need the system time to go into J785.
 
J

JE McGimpsey

Then just leave out the "given cell" in the True branch ( I guess your
use of "add" was confusing to me):

=IF(E785>0, MOD(NOW(),1),"")

which will update whenever the worksheet is calculated.
 
M

Major Tomm

This doesn't seem to be working the way I want it to.
Column E is formated as Date, Column F is formated as Time, I want the
current system time to be added automatically when a date is entered into E.
The formula that you gave was not doing this.
 
J

JE McGimpsey

OK. But what happened to the system time going into column J???
I need the system time to go into J785.
Click to expand...

When you write "I want the current system time to be added automatically
when a date is entered", what do you want it to be added *TO* (i.e., the
just entered date? nothing? some other cell?), and *WHERE* do you want
the result (column F?, column J? somewhere else?)?

I'm sure you have a very clear idea of what you want to accomplish.
Unfortunately, I can't tell from what you've written what that should
look like.
 
M

Major Tomm

I guess I hosed this one up. Sorry about not being very clear, lets say I
am on row 785, I have to add a date to E785 when I finish a project and the
time that I finished needs to go into J785, I have been adding the time in
manually, but I'd like it to happen as soon as I put the date into E785.
lets ignor the F column, I was trying to get the time column(J) closer
because J is too far right (off the screen).
 
L

Loriann

I would like to use the Excel template (from Microsoft site), "weekly time
sheet with breaks", for attendance in a small office/employees to log in
their time. I want them to only be able to enter current system time in the
"IN" and "OUT" cells (and not be able to manually type in another time), to
make sure cheating is not done on their time sheet. Is there a way to do
this?
 
M

Myrna Larson

You could lock these cells and protect the worksheet. Add buttons to enter the
current time into the appropriate cell via a macro (the macro would have to
unprotect the sheet, enter the current date and time, then protect the sheet
again).
 
Top