Go Back   MacRumors Forums > Apple Systems and Services > Mac Basics and Help

Reply
 
Thread Tools Search this Thread Display Modes
Old Nov 14, 2012, 01: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!
jent is offline   0 Reply With Quote
Old Nov 14, 2012, 08:59 PM   #2
r0k
macrumors 68040
 
r0k's Avatar
 
Join Date: Mar 2008
Location: Detroit
Quote:
Originally Posted by jent View Post
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 + (GS4 for work)
Got a scan to ftp scanner? Enable ftpd in Lion/Mavericks/Yosemite!
r0k is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > Mac Basics and Help

Tags
excel, formula, google docs, google drive, spreadsheets

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Google Launches New iOS Apps for Google Docs and Sheets MacRumors iOS Blog Discussion 52 May 7, 2014 02:25 PM
Google Drive Updated to v1.3.xx - Now integrated with Docs & Sheets Lloydbm41 Alternatives to iOS and iOS Devices 0 May 2, 2014 11:10 PM
Why such limited formatting options for docs in Google Drive? rmp71701 iPad Apps 2 Apr 11, 2014 04:22 PM
Sale for Blog Docs - Google Docs™ HTML Editor for WordPress Blogger Tumblr & Email Stevesmith001 iPad Apps 0 Mar 6, 2013 02:31 AM
POLL: Google Drive/Docs vs. MS Office zainiak Community Discussion 7 Aug 21, 2012 05:58 AM

Forum Jump

All times are GMT -5. The time now is 05:47 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC