Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-04-2015, 02:37 AM
medavidcook medavidcook is offline Total Hours * hourly rate Mac OS X Total Hours * hourly rate Office for Mac 2011
Novice
Total Hours * hourly rate
 
Join Date: Jan 2014
Location: Cardiff
Posts: 15
medavidcook is on a distinguished road
Default Total Hours * hourly rate

Hello,

I am trying to calculate my pay via hours and hourly rate but for some reason its coming out at 2.

so far I have input 7hrs 30mins and rate is at 6.66



any ideas.
Reply With Quote
  #2  
Old 06-04-2015, 05:05 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Total Hours * hourly rate Windows 7 64bit Total Hours * hourly rate Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,436
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

Again, it all depends how you enter time (in A1, say)
if its in sexagesimal format (07:30) try A1*24*hourly_rate
If decimal (7.5) then A1*hourly_rate
Reply With Quote
  #3  
Old 06-04-2015, 06:03 AM
medavidcook medavidcook is offline Total Hours * hourly rate Mac OS X Total Hours * hourly rate Office for Mac 2011
Novice
Total Hours * hourly rate
 
Join Date: Jan 2014
Location: Cardiff
Posts: 15
medavidcook is on a distinguished road
Default

didn't work

on April where the hours are they are in cell F8 to f20
and hourly rate is on Schedule page its in cell f4
Reply With Quote
  #4  
Old 06-04-2015, 06:13 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Total Hours * hourly rate Windows 7 64bit Total Hours * hourly rate Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,436
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

No file attached.
Reply With Quote
  #5  
Old 06-04-2015, 06:26 AM
medavidcook medavidcook is offline Total Hours * hourly rate Mac OS X Total Hours * hourly rate Office for Mac 2011
Novice
Total Hours * hourly rate
 
Join Date: Jan 2014
Location: Cardiff
Posts: 15
medavidcook is on a distinguished road
Default

there should be there
Attached Files
File Type: xlsx Workbook3.xlsx (38.3 KB, 2 views)
Reply With Quote
  #6  
Old 06-04-2015, 07:56 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Total Hours * hourly rate Windows 7 64bit Total Hours * hourly rate Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,436
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

Your data is in sexagesimal format so you have to multiply by 24 as I indicated in my previous post.
Before stating " didn't work" please read and apply carefully what has been suggested.
Also check the placement of you parenthesis.
Something like =SUM(YOUR_RANGE*NUMBER) is not the same as =SUM(YOUR_RANGE)*NUMBER
Attached Files
File Type: xlsx Copy of Workbook3.xlsx (16.9 KB, 2 views)
Reply With Quote
  #7  
Old 06-04-2015, 08:07 AM
medavidcook medavidcook is offline Total Hours * hourly rate Mac OS X Total Hours * hourly rate Office for Mac 2011
Novice
Total Hours * hourly rate
 
Join Date: Jan 2014
Location: Cardiff
Posts: 15
medavidcook is on a distinguished road
Default

sorry,

wondering if there is a possible way of just having one sheet with all the hours on and do a if cell is April it adds up cell f
and so on.
Reply With Quote
  #8  
Old 06-04-2015, 09:29 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Total Hours * hourly rate Windows 7 64bit Total Hours * hourly rate Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,436
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

You could build a list with following headers:
Date - Type - In - Out - Total Gross - Total Net

Using SUMIF for example or SUMIFS ( if that exists in Office for Mac), you can extract date for each month and type or, better still using a Pivot Table
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Total Hours * hourly rate Formula to determine Earned Hourly Rate phowe43 Excel 2 06-02-2015 05:51 AM
Total Hours * hourly rate Adding of times total to be in hours jen0dorf Excel 4 06-20-2014 11:53 PM
Total Hours * hourly rate How obtain accurate total of hours estimated of all subtasks that are a certain type? pcumming Project 3 05-14-2014 05:45 PM
Help: Very low response-rate! Jeff10 Office 6 12-17-2013 10:44 AM
Total Hours * hourly rate Monthly Growth Rate Formula meggenm Excel 2 04-22-2013 09:21 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 09:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft