Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Systems and Services > Mac Basics and Help

Reply
 
Thread Tools Search this Thread Display Modes
Old 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!
jent is offline   0 Reply With Quote
Old Nov 14, 2012, 07: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
Got a scan to ftp scanner? Enable ftpd in Mavericks!
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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 04:51 PM.

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

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