Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel: Time Entering
How would I set up a Time format that every time I insert the Time
hh:mm:ss,It will not update automatically example: =NOW() ? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel: Time Entering
If you could do without the seconds, Control-Shift-Colon (or, for date &
time together, Control-Semi-colon space Control-Shift-Colon). -- David Biddulph "Reno747" wrote in message ... How would I set up a Time format that every time I insert the Time hh:mm:ss,It will not update automatically example: =NOW() ? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel: Time Entering
Copy and paste special as values or use VBA (macros)
-- Regards, Peo Sjoblom "Reno747" wrote in message ... How would I set up a Time format that every time I insert the Time hh:mm:ss,It will not update automatically example: =NOW() ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering time | Excel Discussion (Misc queries) | |||
entering negative time values in excel | Excel Discussion (Misc queries) | |||
entering time data | Excel Discussion (Misc queries) | |||
Code for entering time | Excel Discussion (Misc queries) | |||
Entering and Adding Time | Excel Worksheet Functions |