Enter times in 24hr format without the need to use colon ":"

[Excelos]

I am trying to build an excel that will calculate hours worked; based on the difference between a start time and a finish time.

I want to be able to enter times in 24hr format without the need for the Colon (ie 0730 or 1350) as my typing is poor and the colon does my head in. I have seen elsewhere that it can be done but i didnt understand the formula?

[Kevin UK]

Hi Excelos

Try the forum search, this subject was only brought up the other day. See the link below.

http://www.excelforum.com/excel-form...69#post3192269

[Pepe Le Mokko]

This Worksheet Change Module will also help

Please Login or Register  to view this content.

[Excelos]

Thanks Pepe,
I am sorry but I do not know what to do with the worksheet. How do I insert it. Thanks in anticipation.

[Pepe Le Mokko]

Right click the sheet tab
Select View Code - The VBA editor opens
Copy the code in post #3 and paste it in the module
Save via the editor as XLSM file

The code will only work for column A If needed change Range(A:A) to what you need
If the formatting is not what you want, manually change the column/range formatting
Each time you enter the 4 digits, they will be changed to time

[Excelos]

Hello again Pepe

I have done as you suggest except I am unable to Save via the editor as XLSM file.

I have "Sheet 1 (Code) but I cannot save anywhere.

[Pepe Le Mokko]

After pasting the code,while in the VBA editor click ctrl+S - Save As window opens -
In the "Save as Type" drop down select xlsm - Enter the name you need - OK

[Excelos]

Wow, You are a genius. Thank you so much. Next time your in Sydney I'll shout.

Last question. How do I finalise the thread?

[Pepe Le Mokko]

Edit your initial post - Click " Go Advanced" and select " solved" in the dropdown next to the title

Thx for the compliment, but it's just a piece of code I had laying somewhere. I'm totally alien to VBA

[Excelos]

Hello Pepe,

I have the first "start" coloumn working beautifully. I edited the "A;A' to the required coloumn for the start but I cant get the finish to work. How do I get the same result for the "finish" coloumn. I have tried copying and editing the command but I have no idea. It is late here now and I must go. I will be back tomorrow and hope that you can continue to help me. Thank you.