Thread: Formula requireing the system time:current time

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

one way:

Assume: "given cell" is A1

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

Format as time if necessary.

In article <821F5EDD-CBF0-41E3-B37C-5249D1A7AAF8@microsoft.com>,
"Major Tomm" <MajorTomm@discussions.microsoft.com> wrote:

> 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

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.

"JE McGimpsey" wrote:

> one way:
>
> Assume: "given cell" is A1
>
> =IF(A1>0,A1 + MOD(NOW(),1),"")
>
> Format as time if necessary.
>
> In article <821F5EDD-CBF0-41E3-B37C-5249D1A7AAF8@microsoft.com>,
> "Major Tomm" <MajorTomm@discussions.microsoft.com> wrote:
>
> > 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
>

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.


In article <0BB21E9E-6127-4860-8BEF-29388CCD3019@microsoft.com>,
"Major Tomm" <MajorTomm@discussions.microsoft.com> wrote:

> 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.
>
> "JE McGimpsey" wrote:
>
> > one way:
> >
> > Assume: "given cell" is A1
> >
> > =IF(A1>0,A1 + MOD(NOW(),1),"")
> >
> > Format as time if necessary.
> >
> > In article <821F5EDD-CBF0-41E3-B37C-5249D1A7AAF8@microsoft.com>,
> > "Major Tomm" <MajorTomm@discussions.microsoft.com> wrote:
> >
> > > 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
> >

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.


"JE McGimpsey" wrote:

> 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.
>
>
> In article <0BB21E9E-6127-4860-8BEF-29388CCD3019@microsoft.com>,
> "Major Tomm" <MajorTomm@discussions.microsoft.com> wrote:
>
> > 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.
> >
> > "JE McGimpsey" wrote:
> >
> > > one way:
> > >
> > > Assume: "given cell" is A1
> > >
> > > =IF(A1>0,A1 + MOD(NOW(),1),"")
> > >
> > > Format as time if necessary.
> > >
> > > In article <821F5EDD-CBF0-41E3-B37C-5249D1A7AAF8@microsoft.com>,
> > > "Major Tomm" <MajorTomm@discussions.microsoft.com> wrote:
> > >
> > > > 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
> > >
>

OK. But what happened to the system time going into column J???

> I need the system time to go into J785.

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.


In article <8342F16D-7CC8-43EB-8E38-3F8F2F36E091@microsoft.com>,
"Major Tomm" <MajorTomm@discussions.microsoft.com> wrote:

> 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.
>
>
> "JE McGimpsey" wrote:
>
> > 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.
> >
> >
> > In article <0BB21E9E-6127-4860-8BEF-29388CCD3019@microsoft.com>,
> > "Major Tomm" <MajorTomm@discussions.microsoft.com> wrote:
> >
> > > 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.
> > >
> > > "JE McGimpsey" wrote:
> > >
> > > > one way:
> > > >
> > > > Assume: "given cell" is A1
> > > >
> > > > =IF(A1>0,A1 + MOD(NOW(),1),"")
> > > >
> > > > Format as time if necessary.
> > > >
> > > > In article <821F5EDD-CBF0-41E3-B37C-5249D1A7AAF8@microsoft.com>,
> > > > "Major Tomm" <MajorTomm@discussions.microsoft.com> wrote:
> > > >
> > > > > 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
> > > >
> >

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).


"JE McGimpsey" wrote:

> OK. But what happened to the system time going into column J???
>
> > I need the system time to go into J785.
>
> 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.
>
>
> In article <8342F16D-7CC8-43EB-8E38-3F8F2F36E091@microsoft.com>,
> "Major Tomm" <MajorTomm@discussions.microsoft.com> wrote:
>
> > 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.
> >
> >
> > "JE McGimpsey" wrote:
> >
> > > 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.
> > >
> > >
> > > In article <0BB21E9E-6127-4860-8BEF-29388CCD3019@microsoft.com>,
> > > "Major Tomm" <MajorTomm@discussions.microsoft.com> wrote:
> > >
> > > > 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.
> > > >
> > > > "JE McGimpsey" wrote:
> > > >
> > > > > one way:
> > > > >
> > > > > Assume: "given cell" is A1
> > > > >
> > > > > =IF(A1>0,A1 + MOD(NOW(),1),"")
> > > > >
> > > > > Format as time if necessary.
> > > > >
> > > > > In article <821F5EDD-CBF0-41E3-B37C-5249D1A7AAF8@microsoft.com>,
> > > > > "Major Tomm" <MajorTomm@discussions.microsoft.com> wrote:
> > > > >
> > > > > > 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
> > > > >
> > >
>

Ah, a completely different solution:

http://www.mcgimpsey.com/excel/timestamp.html


In article <D86F3886-4926-4A66-9EE1-9F9712A69DD3@microsoft.com>,
"Major Tomm" <MajorTomm@discussions.microsoft.com> wrote:

> 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).