Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

6 points

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

Best reply

Level 8

35,348 points

Posted on Jul 24, 2019 11:16 AM

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.

View in context

Similar questions