| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
realtime
Hi,
With which command can I "import" or enter the time e.g. 11.30 in excel..? I would like to make a spread sheet with time in and out of office... Appreciate any kind of help€¦ Regards Mats |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
realtime
One quick way is
Ctrl+Shift+; Mike "Mats" wrote: Hi, With which command can I "import" or enter the time e.g. 11.30 in excel..? I would like to make a spread sheet with time in and out of office... Appreciate any kind of help€¦ Regards Mats |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
realtime
If you want to enter a time-stamp into a cell, hold down CTRL and
SHIFT and press the semicolon key. Hope this helps. Pete On Nov 12, 10:36 am, Mats wrote: Hi, With which command can I "import" or enter the time e.g. 11.30 in excel..? I would like to make a spread sheet with time in and out of office... Appreciate any kind of help... Regards Mats |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
realtime
"Mats" wrote in message
... Hi, With which command can I "import" or enter the time e.g. 11.30 in excel..? I would like to make a spread sheet with time in and out of office... Appreciate any kind of help. Regards Mats If you are asking how you enter any time value into a cell, you should use a colon as the delimiter between hours and minutes, for example 11:30 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
realtime
Thanks!
"Mike H" wrote: One quick way is Ctrl+Shift+; Mike "Mats" wrote: Hi, With which command can I "import" or enter the time e.g. 11.30 in excel..? I would like to make a spread sheet with time in and out of office... Appreciate any kind of help€¦ Regards Mats |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
realtime
Thanks!
"Stephen" wrote: "Mats" wrote in message ... Hi, With which command can I "import" or enter the time e.g. 11.30 in excel..? I would like to make a spread sheet with time in and out of office... Appreciate any kind of help. Regards Mats If you are asking how you enter any time value into a cell, you should use a colon as the delimiter between hours and minutes, for example 11:30 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
realtime
Thanks!
"Pete_UK" wrote: If you want to enter a time-stamp into a cell, hold down CTRL and SHIFT and press the semicolon key. Hope this helps. Pete On Nov 12, 10:36 am, Mats wrote: Hi, With which command can I "import" or enter the time e.g. 11.30 in excel..? I would like to make a spread sheet with time in and out of office... Appreciate any kind of help... Regards Mats |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
realtime
You're welcome - thanks for taking the trouble to feedback to
everyone. Pete On Nov 14, 8:02 am, Mats wrote: Thanks! "Pete_UK" wrote: If you want to enter a time-stamp into a cell, hold down CTRL and SHIFT and press the semicolon key. Hope this helps. Pete On Nov 12, 10:36 am, Mats wrote: Hi, With which command can I "import" or enter the time e.g. 11.30 in excel..? I would like to make a spread sheet with time in and out of office... Appreciate any kind of help... Regards Mats- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "freeze" an imported realtime updated cell value | Excel Worksheet Functions | |||
| History for Realtime measurement | Excel Discussion (Misc queries) | |||
| Realtime chart example | Excel Discussion (Misc queries) | |||
| Realtime Automatic sorting of data in rows in new work sheet | Excel Worksheet Functions | |||
| extract data from a realtime updated cell | Excel Discussion (Misc queries) | |||
Linear Mode
