Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
 MacRumors Forums Calculating daily payment in Google Drive/Docs

 Nov 14, 2012, 12:10 PM #1 jent macrumors 6502a   Join Date: Mar 2010 Calculating daily payment in Google Drive/Docs I am setting up a shared spreadsheet in Google Drive that I share with my boss to act as a timesheet. I've set it up so that I input the date, time in, and time out, and it automatically calculates the daily hours worked and total hours worked. These are formatted as "Hours" in the spreadsheet. I have two questions. Firstly, with Google Drive spreadsheets is there a way to format numbers as "Hours" but not have it include seconds? If I worked for a total of three and a half hours, for example, it reads "3:30:00"—which is a bit redundant for an informal timesheet. Secondly, I'm trying to create a column to calculate my daily pay. In the column for daily hours worked, I list my hours in the "Hours" number format. I want to list my daily and total pay in the currency number format. What formula should I use so that Google Drive knows that "3:30:00" means 3.5, thus multipliable by the number of hours and resulting in the daily pay. Thanks for any help! 0
Nov 14, 2012, 07:59 PM   #2
r0k
macrumors 68040

Join Date: Mar 2008
Location: Detroit
Quote:
 Originally Posted by jent I am setting up a shared spreadsheet in Google Drive that I share with my boss to act as a timesheet. I've set it up so that I input the date, time in, and time out, and it automatically calculates the daily hours worked and total hours worked. These are formatted as "Hours" in the spreadsheet. I have two questions. Firstly, with Google Drive spreadsheets is there a way to format numbers as "Hours" but not have it include seconds? If I worked for a total of three and a half hours, for example, it reads "3:30:00"—which is a bit redundant for an informal timesheet. Secondly, I'm trying to create a column to calculate my daily pay. In the column for daily hours worked, I list my hours in the "Hours" number format. I want to list my daily and total pay in the currency number format. What formula should I use so that Google Drive knows that "3:30:00" means 3.5, thus multipliable by the number of hours and resulting in the daily pay. Thanks for any help!
Google docs supports many of the functions of excel, numbers, and open office. If I were entering a spreadsheet that I wanted to be easily used to calculate pay, I would NOT bother with time formats. I would enter the hours as decimals like 1.5 hours or 7.5 hours. Of course there are string functions that can be used to "parse" time and convert it to fractions but I think that's way too much heavy lifting. Stick with hours and decimal fractions of hours. I would think that timekeeping should have resolution to 1/2 or even 1/4 hour and no more, right? If you are down to minute or second based timekeeping, perhaps google docs isn't the appropriate tool.
__________________
-r0k
Macbook Pro (late 2011) iPad mini iPhone5
Got a scan to ftp scanner? Enable ftpd in Mavericks!
0