Excel - Multiplying A Rate By Hours

chateauneufdupape

I am trying to set up a spreadshet that calculates the hours worked and then multiply them by a rate. Cell D2 is the start time, cell D3 is the finish time, cell D4 is the hours worked (D3-D2), cell D5 is the rate and cell D6 is the total cost (D4*D5). However, whilst cell D4 gives the correct answer, D6 does not. How do i get around this?

meclive

Not too sure what your after but i tried to follow your post and made this basic example which seems to work ok. I just formatted the cells as a decimal number and the rate and total as currency. Hope it helps or let me know if im way of target lol.

Example Here

tigermatt

I had this problem a while ago - a search for employee wages excel brought up a few results which may be of use.

chateauneufdupape

It seems to be related to fomatting, Cell D2 and D3 were in h:m format. I solved this using D4 "=HOUR(D3-D2)"

Thanks for the thoughts

Stompa

It seems to be related to fomatting, Cell D2 and D3 were in h:m format. I solved this using D4 "=HOUR(D3-D2)"

I suspect that's not what you want, you're effectively rounding down the time worked to the nearest whole hour.

Safer to use: =24*(D3-D2)

Stompa

tigermatt

chateauneufdupape wrote:

Cell D2 and D3 were in h:m format.

Probably not related, but a useful piece of info to know: When adding times in Excel, you can't use one of the pre-defined time formats on your total cell - you have to use Custom then specify [h]:mm to prevent the hours rolling over at 24 hours and starting again.