Forum Discussion
Multiplying time (for wage calculations).
Chapman,
It's simpler than you imagine!
This little formula is all you need:
=A2*24*B2
That doesn't matter which format do you apply to the cell, value in it is not changed with change of the format. For example, here are different formats applied to the cells which have exactly the same value in them
Dates in Excel are sequential integer numbers where 1 is equal to 01 Jan 1900. Time is decimal part of the number, thus 1 hours equals to 1/24.
If time elapsed format shows 91:00 it is equal to 3 and 19/24 days. In 1 day there are 24 hours, thus above is 3.7916666667*24 = 91 if we'd like to have number of hours.
Thus in you case Total to pay =24*G23*G24
Thank you so much for clarifying!
(I guess since G23 is already showing the total hours, I did not think to try multiplying it by 24 hours again.)
yoyoyojoe , you are welcome