# Format problem calculating salary

Copper Contributor

# Format problem calculating salary

I want to calculate salary. I enter hours 'from' and 'to' using Format Time: 13:30. Then I add the days in a cell using Format Custom: [h:mm]. I add the four weeks using the format Custom: [h}:mm. So far so good.

How do I take, let say, 149 hours and 3/4 - that is 149.45 - and dividing those hours by 20 and then multiply by \$17.75 so that I end up in the cell with a format that will give me \$132.91.

Thank you

5 Replies

# Re: Format problem calculating salary

How do I take, let say, 149 hours and 3/4 - that is 149.45....

Stop: 3/4 is .75 so 149 and 3/4 hours would be 149.75

The formula would be =(149.75/20)*17.75

or, better, refer to the cells containing those various values. My calculator gave me \$132.90, for what that's worth.

(What, by the way, is the source of the 20?)

# Re: Format problem calculating salary

@mathetesHello, 3/4 of kan hour is really 45 minutes as there are 60 minutes in an hour.

The 20 is just the numbe to use to calculte the holiday to pay, it is based on  the last 4 weeks of paid hours.

# Re: Format problem calculating salary

3/4 of kan hour is really 45 minutes as there are 60 minutes in an hour.

Yes, but 149.45 is a decimal number: 149 and 45/100, not 149 and 45/60.

As a decimal number, you should use 149.75 since .75 = 75/100 = 3/4.

It's different if you use time format: 149:45 is indeed 149 and 45/60. But that is not what you used in your calculation.

# Re: Format problem calculating salary

Hi, I looked again at my sheet, following your response.
So, to be succinct, I calculate the hours with the format Custom [h]:mm. That will brake the hour by 15 minutes period.
So, From 06:00 To 16:15 that would give 10.15 or 10 hours and 1/4.
The problem I have is that I need to divide the sum for a pay period, let say 119.45 by 20 to get the number of hours for 1 day (for holidays) and that does not work because 119.45 /20 does note equal 119.75 / 20.

I could enter the time with decimal but the entry time would take too much time and errors easy to commit, it is more efficient to enter the hours like form 06:00 to 14:45 because the calculation are exact. But I can not multiply hourly salary without using many columns trying to convert decimal. I can not multiply the hours by hourly salary because the total would be different. How do I work with these 2 formats? Do I have to convert the digit '20', do I have to convert the hourly salary (but how) so that I get the correct result?

# Re: Format problem calculating salary

Sorry to be pedantic, but from 6:00 to 16:15 is not 10.15. It is 10:15

If you want to convert this to decimal hours, multiply with 24 and format as General or as Number.

You can then divide by 20 if required.