Jun 17, 2009

Time sheets in Google: Displaying time as hours duration, not hours date

Both the "=hour(hours)" and "=time(hours,minutes,seconds)" functions of Google Spreadsheets are time values. This means that they will display what hour of the day your current input will be. This can be frustrating when a creating a time sheet.

After setting a format to "Hours" (under the 123 dropdown), the time function will still insist on using an hour of the day number. If you put in an int without a function, you'll have the number of days written out in the hours format.

To get around this, set up a normal column for your int hours, and set up an hours column with the function "=([hoursCell]/24)".

No comments: