realtime

G

Guest

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
 
P

Pete_UK

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
 
S

Stephen

Mats said:
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
Click to expand...

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
 
G

Guest

Thanks!

Stephen said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WHY Cant anyone answer my question 4
"freeze" an imported realtime updated cell value 6
SAVED CHANGES CAN NOT FIND SHEET WHERE WOULD IT BE 1
Importing External Data function 1
dynamic data copying between worksheets 0
import stock prices from discount broker acct 2
Random Numbers excluding Previous Numbers 2
Locating values in a range and bringing up the corresponding price 3

Top