Time Issue

[Kombat78]

Hi all the experts,

I need a little help. I am entering time into a rather large spreadsheet. I need to bypass the colon entering part as it slows the process down immensely.
Is there anyway to just enter the 4 digits and create a cell format to change it to time. But still be able to use it in calculations.

Thank you in advance

Time.jpg

http://www.excelforum.com/attachment...1&d=1457594677

[Pepe Le Mokko]

Perhaps try http://www.cpearson.com/Excel/DateTimeEntry.htm or Google around for " Military time"

[Toonies]

try this

Format Time ON and Time OUT cells

Please Login or Register  to view this content.

this inserts ":" colon into your number (it will always remain a number that looks like time)

ie: when you input

800 it displays as 8:00
830 it displays as 8:30

etc

then copy down your required range


in E6 put the following formula and copy down

Please Login or Register  to view this content.

format as [h]:mm

I have noticed further down that you have the following formula

D259

Please Login or Register  to view this content.

it still gives the required result

hope this helps you

Toonies

[Toonies]

if you still want a vba solution

this is created by on of the Excel Guru's on here(I cannot recall who) and I take no credit it's all theirs


800 it displays as 8:00
830 it displays as 8:30

etc

I have put the 1st 5 ranges in

Please Login or Register  to view this content.