Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get time entered automatically in A1 if B1 has text
I'm creating a log sheet that will have entries every few minutes in the
second cell or column B. I need the time to be automatically entered in A each time. Is this possible? I've tried several formulas with no luck. The closest formula that I can get is =IF(B1=1, "NOW()") however this will return an error. If this were to work then a 1 would have to be entered in B1. I tried using a wildcard with no luck also. Time taken from the computer clock is entered as =NOW() Please help if you can Thanks Tim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get time entered automatically in A1 if B1 has text
=IF(B1=1, "NOW()") does not return an error in Excel 2007, it returns the
words "NOW()" if B1 is equal to 1 and FALSE if B1 is not equal to 1. Just as the formula specifies. Quotes make a difference. Did you want the formula to return the date and time of day as in NOW() or did you want the literal "NOW()". If you want the date and time of day, then =IF(B1=1, NOW()) If B1 is equal to 1 you get the date and time and if not equal to 1, the formula returns FALSE. If you want 0 then perhaps =IF(B1=1, NOW(),0) Tyro "Sergeant Henderson USAF" <Sergeant Henderson wrote in message ... I'm creating a log sheet that will have entries every few minutes in the second cell or column B. I need the time to be automatically entered in A each time. Is this possible? I've tried several formulas with no luck. The closest formula that I can get is =IF(B1=1, "NOW()") however this will return an error. If this were to work then a 1 would have to be entered in B1. I tried using a wildcard with no luck also. Time taken from the computer clock is entered as =NOW() Please help if you can Thanks Tim |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get time entered automatically in A1 if B1 has text
If you want that time to be static, then you can't use a formula.
=now() will update whenever excel recalcs. But you could use a macro. In fact, JE McGimpsey has ready for you: http://www.mcgimpsey.com/excel/timestamp.html If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Sergeant Henderson USAF wrote: I'm creating a log sheet that will have entries every few minutes in the second cell or column B. I need the time to be automatically entered in A each time. Is this possible? I've tried several formulas with no luck. The closest formula that I can get is =IF(B1=1, "NOW()") however this will return an error. If this were to work then a 1 would have to be entered in B1. I tried using a wildcard with no luck also. Time taken from the computer clock is entered as =NOW() Please help if you can Thanks Tim -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get time entered automatically in A1 if B1 has text
Tyro,
You are correct and that formula did work. Is there any way to make it a variable or wildcard. In other words - if B1 has anything at all in it - can A1 display the date and time? Thanks Tim "Tyro" wrote: =IF(B1=1, "NOW()") does not return an error in Excel 2007, it returns the words "NOW()" if B1 is equal to 1 and FALSE if B1 is not equal to 1. Just as the formula specifies. Quotes make a difference. Did you want the formula to return the date and time of day as in NOW() or did you want the literal "NOW()". If you want the date and time of day, then =IF(B1=1, NOW()) If B1 is equal to 1 you get the date and time and if not equal to 1, the formula returns FALSE. If you want 0 then perhaps =IF(B1=1, NOW(),0) Tyro "Sergeant Henderson USAF" <Sergeant Henderson wrote in message ... I'm creating a log sheet that will have entries every few minutes in the second cell or column B. I need the time to be automatically entered in A each time. Is this possible? I've tried several formulas with no luck. The closest formula that I can get is =IF(B1=1, "NOW()") however this will return an error. If this were to work then a 1 would have to be entered in B1. I tried using a wildcard with no luck also. Time taken from the computer clock is entered as =NOW() Please help if you can Thanks Tim |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get time entered automatically in A1 if B1 has text
On Mar 17, 7:04*am, Sergeant Henderson USAF
wrote: Tyro, You are correct and that formula did work. Is there any way to make it a variable or wildcard. In other words - if B1 has anything at all in it - can A1 display the date and time? Thanks Tim "Tyro" wrote: =IF(B1=1, "NOW()") does not return an error in Excel 2007, it returns the words "NOW()" *if B1 is equal to 1 and FALSE if B1 is not equal to 1. Just as the formula specifies. Quotes make a difference. Did you want the formula to return the date and time of day as in NOW() or did you want the literal "NOW()". If you want the date and time of day, then =IF(B1=1, NOW()) If B1 is equal to 1 you get the date and time and if not equal to 1, the formula returns FALSE. If you want 0 then perhaps =IF(B1=1, NOW(),0) Tyro "Sergeant Henderson USAF" <Sergeant Henderson wrote in message ... I'm creating a log sheet that will have entries every few minutes in the second cell or column B. I need the time to be automatically entered in A each time. Is this possible? I've tried several formulas with no luck. The closest formula that I can get is =IF(B1=1, "NOW()") however this will return an error. If this were to work then a 1 would have to be entered in B1.. I tried using a wildcard with no luck also. Time taken from the computer clock is entered as =NOW() Please help if you can Thanks Tim- Hide quoted text - - Show quoted text - If any value or text existing in B1, A1 displays the date & time =IF(B10,NOW()," ") |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get time entered automatically in A1 if B1 has text
Thank you very much guys - I do appreciate the time. I can work with this
information. MSgt H. "Dave Peterson" wrote: If you want that time to be static, then you can't use a formula. =now() will update whenever excel recalcs. But you could use a macro. In fact, JE McGimpsey has ready for you: http://www.mcgimpsey.com/excel/timestamp.html If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Sergeant Henderson USAF wrote: I'm creating a log sheet that will have entries every few minutes in the second cell or column B. I need the time to be automatically entered in A each time. Is this possible? I've tried several formulas with no luck. The closest formula that I can get is =IF(B1=1, "NOW()") however this will return an error. If this were to work then a 1 would have to be entered in B1. I tried using a wildcard with no luck also. Time taken from the computer clock is entered as =NOW() Please help if you can Thanks Tim -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get time entered automatically in A1 if B1 has text
Suggested reading. John Walkenbach's Excel Bible books, $40.
Http:/j-walk.com/ss Tyro "Sergeant Henderson USAF" wrote in message ... Thank you very much guys - I do appreciate the time. I can work with this information. MSgt H. "Dave Peterson" wrote: If you want that time to be static, then you can't use a formula. =now() will update whenever excel recalcs. But you could use a macro. In fact, JE McGimpsey has ready for you: http://www.mcgimpsey.com/excel/timestamp.html If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Sergeant Henderson USAF wrote: I'm creating a log sheet that will have entries every few minutes in the second cell or column B. I need the time to be automatically entered in A each time. Is this possible? I've tried several formulas with no luck. The closest formula that I can get is =IF(B1=1, "NOW()") however this will return an error. If this were to work then a 1 would have to be entered in B1. I tried using a wildcard with no luck also. Time taken from the computer clock is entered as =NOW() Please help if you can Thanks Tim -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter text automatically based on current time | Excel Discussion (Misc queries) | |||
integers entered automatically divide by 10 | New Users to Excel | |||
Automatically entered decimal point. | Excel Worksheet Functions | |||
How to automatically insert date when text entered in neighboring | Excel Discussion (Misc queries) | |||
I need a time sheet template that verifies time entered against sy | Excel Discussion (Misc queries) |