calculator time sheet with pay wage

I could not figure out how to calculate my work hours with pay wage on my timesheet

I try =sum(D3x$10). I get day and hour. What should I do?

Posted on Jul 24, 2019 11:08 AM

Similar questions

Numbers timesheet What would be the formula for calculating pay earned? I have calculated total hours from start time and end time, but when I try to calculate pay earned from total hours multiplied by a dollar amount, the result appears in duration, not currency. Thanks! Tiffany
372 3
Calculate 0h durations in a timesheet? My job requires us to turn in timesheets for each pay period and I am trying to turn it digital to make it a little easier. In the process, I have gotten Numbers to calculate the durations I need unless there is no time present. If I don't have a clock in/out present, the calculation is 0 rather than 0h and it throws everything off. I tried changing the cell format to duration but when I click off the cell and go back to it, it changes back to automatic. I tried doing an if statement in the function but if I try to type any duration into the function (i.e. 0h) it simply won't let me. Is there a way to get the calculation to default to 0h if there isn't a time present to calculate?
659 2
How to sum hours if they are after certain hour Hi, I'm tracking my working hours but i've run into this problem. Every hour worked after 10PM is worth 20.63% more per hour. What I'm trying to do is to use a conditional so Numbers will count all my hours worked after 10PM and add them up to multiply by the value, so I can then add it to my base salary. Is there a way to do this or should I just keep adding my hours by myself and calculating the product every time? Here is an example where I calculated my night hours (hours worked after 10PM) and then did PRODUCT(week D10, values B2) and added it up to the base pay on Total pay.
349 2

1 reply

SGIII

Level 8

37,550 points

Jul 24, 2019 11:16 AM in response to deafie

deafie wrote:

I try =sum(D3x$10). I get day and hour. What should I do?

Try this:

=DUR2HOURS(D3)*10

DUR2HOURS converts the 3h to a decimal number. You can then multiply that by the dollars per hour, which I assume from your example is 10.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

calculator time sheet with pay wage

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up