Jul 9, 2025
Оfftopic Community
Оfftopic Community
Forums
New posts
Search forums
What's new
Featured content
New posts
New media
New media comments
New resources
New profile posts
Latest activity
Media
New media
New comments
Search media
Resources
Latest reviews
Search resources
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Technology
Software & Hardware
In Excel how can you calculate Salary per hour by time worked?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="avoiding the ironing" data-source="post: 435486"><p>HELP!</p><p></p><p>I have columns of start time, end time, break, and gross hours</p><p>Then one with the rate of pay.</p><p></p><p>eg. So if I enter times and it correctly calculated I work 5 hours it shows as 5:00 hours as it's formatted as [h]:mm</p><p>Or if I work 4 and half hours it shows as 4:30</p><p>Or 4 and quater it's 4:15</p><p>Or 4 and three quaters it's 4:45</p><p></p><p>But I want to calculate the rate of pay by this.</p><p></p><p>SO the cell with the rate of pay in formatted as a number with 2 decimal spaces. eg £6.00.</p><p></p><p>What formatting do I need in the answer cell to give me the correct answer. The non whole hours totall throw me!</p></blockquote><p></p>
[QUOTE="avoiding the ironing, post: 435486"] HELP! I have columns of start time, end time, break, and gross hours Then one with the rate of pay. eg. So if I enter times and it correctly calculated I work 5 hours it shows as 5:00 hours as it's formatted as [h]:mm Or if I work 4 and half hours it shows as 4:30 Or 4 and quater it's 4:15 Or 4 and three quaters it's 4:45 But I want to calculate the rate of pay by this. SO the cell with the rate of pay in formatted as a number with 2 decimal spaces. eg £6.00. What formatting do I need in the answer cell to give me the correct answer. The non whole hours totall throw me! [/QUOTE]
Insert quotes…
Name
Verification
Please enable JavaScript to continue.
Loading…
Post reply
Top