| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
? enter a static time (Excel) in a cell using the IF function
Is a macro ok?
Take a look at JE McGimpsey's site: http://www.mcgimpsey.com/excel/timestamp.html pmcfs111 wrote: I am trying to automatically enter a static time into a cell based on another cells content. I have discovered that the NOW() does not work and it defeats my purpose to use "Ctrl Shift + ;" Any help would be appreciated, thanks -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| static time with if function | Excel Discussion (Misc queries) | |||
| automatically enter today's date as a static entry in Excel | Excel Discussion (Misc queries) | |||
| cell with static current time | Excel Worksheet Functions | |||
| enter a static time dependent upon another cell value | Excel Discussion (Misc queries) | |||
| How to enter current static time in Excel in 00:00:00.0 format? | Excel Worksheet Functions | |||
Linear Mode
