time formula
 

hi
i have been trying to insert current time in a cell in excel 2007 only
when another cell has been filled but am having trouble with the formula,
here is what i have so far =IF(B6<"","= time"," ") this just
displays = Time in the cell instead of the time. any help greatly
appreciated

cheers
rslc

time formula
 

Try using =Now() instead of time

"rslc" wrote:

hi
i have been trying to insert current time in a cell in excel 2007 only
when another cell has been filled but am having trouble with the formula,
here is what i have so far =IF(B6<"","= time"," ") this just
displays = Time in the cell instead of the time. any help greatly
appreciated

cheers
rslc

time formula
 

this will do what you want, but the time will change with every calc

=IF(B6<"",TEXT(NOW(),"hh:mm"),"")

--

Gary
Excel 2003


"rslc" wrote in message ...
hi
i have been trying to insert current time in a cell in excel 2007 only
when another cell has been filled but am having trouble with the formula,
here is what i have so far =IF(B6<"","= time"," ") this just
displays = Time in the cell instead of the time. any help greatly
appreciated

cheers
rslc

time formula
 

There is probably another way but =now()-today() will give you the
current time ( don't forget to format as hh:mm:ss)
This is a volatile formula so it will recalculate each time the sheet
is accessed or changed


--
Pecoflyer

Cheers
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=33000

time formula
 

Thanks for the reply Gary unfortunetly the time changing is what i'm trying
to avoid, i can use = time to enter current time and not have it
change but have not been able to get it to work in my formula.

cheers
rslc


"Gary Keramidas" wrote in message
...
this will do what you want, but the time will change with every calc

=IF(B6<"",TEXT(NOW(),"hh:mm"),"")

--

Gary
Excel 2003


"rslc" wrote in message ...
hi
i have been trying to insert current time in a cell in excel 2007 only
when another cell has been filled but am having trouble with the formula,
here is what i have so far =IF(B6<"","= time"," ") this just
displays = Time in the cell instead of the time. any help greatly
appreciated

cheers
rslc

time formula
 

HI Gary
thanks for the reply, but unfortunetly thats what i was
trying to avoid. I can use = time which will give me the result i want
but haven't been able to get it to work in my formula

cheers

rslc

"Gary Keramidas" wrote in message
...
this will do what you want, but the time will change with every calc

=IF(B6<"",TEXT(NOW(),"hh:mm"),"")

--

Gary
Excel 2003


"rslc" wrote in message ...
hi
i have been trying to insert current time in a cell in excel 2007 only
when another cell has been filled but am having trouble with the formula,
here is what i have so far =IF(B6<"","= time"," ") this just
displays = Time in the cell instead of the time. any help greatly
appreciated

cheers
rslc