Posts Tagged ‘time’

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 […]

Human Time Format Gone Wrong

Wednesday, January 28th, 2009 by Jesper Rønn-Jensen

In general it’s good to use the human time formats (1 hour ago, 2 months ago, etc.) that you see in many of the new web applications. In general, the detail level is up the shorter the time span.