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