excel timesheet - time format

**kocco** · 04-04-2012, 01:34 AM

Hi guys,

i need little help from you once again

I have excel timesheet...everything works well....but I would like to make it more advanced..

In time sheet, there is Time In and Time out etc. I have it (and I need it to have) formatted to [h]:mm (24 h format - 13:45 example)

When I want to fill this up, I have to type manually 13:45..I would like to have it like this: I type 1345 and when I move to another cell its gonna format automatically to 13:45...

Is this possible?....

here is sample timesheet to help you understand what I actually need

timesheet_example.xlsx

**dilipandey** · 04-04-2012, 01:47 AM

Ok.... so basically you want to avoid typing in colon sign (

... and you just want enter 1345 and the moment you press enter, it should automatically be change to 13:45?

Regards,
DILIPandey

<click on below 'star' if this helps>

**kocco** · 04-04-2012, 01:50 AM

Yep...exactly like you said

**kocco** · 04-04-2012, 01:56 AM

Actually...it should not be strictly on ENTER press...the absolutely best would be on leaving cell or something like that...because usually when you press ENTER, you'll move to cell below...and I need to move to cell which is next on the right....