[Question] Excel Spreadsheet to calculate weekly wages

[Dientjie]

Good Morning,

I would like to use an excel spreadsheet to generate weekly wages. I would like to add hours (example 2hours 42min + 5hours 39minutes = 8hours 21minutes BUT if I type in 2.42 and 5.39 into a cell and add it gives me 7.81which is incorrect and would cause me to underpay my staff) How can I do this?

[Dientjie]

Issue has been resolved :-)

[IanF]

Dientjie
How did you do this, I have never managed in excel so gave up as it was quicker for me to do manually.
So teach us the tricks.

[HR Solutions]

I have got one
Just break up your hours and minutes into two different cells, then use your formulas in different cells to get your totals hours and minutes.
The minutes cell you have to basically divide by 60 to get hours.
You can then put in your hourly rate or weekly rate and less your uif/paye in two separate cells and get
your total at the end.

[Dientjie]

Good Morning Ian,

In the cell you want to put the hours in select format cells - on the number tab select "custom" and look for [h]:mm:ss. Type in your hours (example 48:45 -48hours 45 minutes) Make sure all your cells are in this format and sum - viola!!

If you want to multiply the total hours with an hourly rate make sure your formula says =A1 (total hours worked)*A2(rate per hour)*24

If you need help let me know....

[IanF]

Dientjie you beaut, that worked for calculating minutes per KM in excel. I couldn't figure that out.

[Dientjie]

Glad I could help :-)