Posts Tagged ‘office’

Automatic Excel Time Format Without Colon in Input

Wednesday, January 5th, 2011 by Jesper Rønn-Jensen

For a simple Excel sheet time reporting, i needed to enter hours every day for arrival and departure time. Excel is not so smart about the time format. For instance I need to enter “9:00” for nine in the morning. I wanted just to enter “900”, and let the excel sheet format the data correctly […]