|Nov 14, 2012, 01:10 PM||#1|
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!
|Nov 14, 2012, 08:59 PM||#2|
|excel, formula, google docs, google drive, spreadsheets|
|Thread Tools||Search this Thread|
|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|
All times are GMT -5. The time now is 06:31 PM.