Format Cell for Time

[Pascal]

Hi,

I'd like to know if it's possible, I'm sure it is, to format a column so that when I enter time in to one of the cells I can just enter 0805 and it is then automatically formatted to 08:05.

I just want to do it to save a little time.

I've looked at formatting the cells as hh:mm, but upon entering 0805 it appears as 00:00 and 15/03/1902 00:00:00 when I click on the cell.

Even better would be if it allowed me to just enter 0805 and then displays it as 08:05, but has converted it to 31/07/2013 08:05.

Any ideas on how to achieve the auto formatting?

Many Thanks & Regards

 

[sdsurzh]

Hi,

Insert a module and paste the below code and use CONTROL + T. This code will enter the current time and convert them to values.

Hope this will help you.

Sub timeformat()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+t
'
ActiveCell.FormulaR1C1 = "=NOW()"
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
End Sub

Thanks,
SK

 

[Pascal]

Hi,

Thanks for the reply, but I'm not sure how this helps?

I've carried out your steps, but when I enter 1308 into a Cell it just displays 1308.

How does this code format the Cell I've just entered my time into?

Regards

 

[Andrew Poulsom]

Look here:

Date And Time Entry

 

[Pascal]

Look here:

Date And Time Entry

Many Thanks Andrew, looks like that's just what I require.

Best Regards