Forum Discussion
Solved
Multiplying time (for wage calculations).
Hi.
I’m new to the community (and a bit of an excel amateur). Just joined as I have an issue which I think is quite simple, but to which I can’t find a solution.
Basically I’m trying to add up ho...
Chapman,
It's simpler than you imagine!
This little formula is all you need:
=A2*24*B2
Your answer works great until the number of hours worked is greater than 24. For example, if you put 25:00 into the time column, it automatically converts to 1:00 and the pay column is reduced to one hour's pay.
I haven't found the proper solution yet.
Mindanser if you put 25:00 is in the column it will be 1:00 so the answer is the salary they gave you to work on
25:00 will be shown as 01:00 if to use time format hh:mm. But if to use elapsed time format [hh]:mm it will be shown as 25:00.
In both cases the value will be exactly the same, format is only define how to show such value.
