jordan11221992
New Member
- Joined
- Jan 2, 2021
- Messages
- 22
- Office Version
- 365
- 2010
- Platform
- Windows
On sheet 1 i ha e my schedule monday-sunday with everyones in and out times for each day of the week. On sheet 2 i have the same template but for example sheet 1, c12 is in time d12 is out time. On sheet 2 i have b2='sheet1'!d12-'sheet1'!c12 to give me the total hours for the day sheet 1 says 7:00 a.m. in c12 and 6:00 p.m. in d12. On sheet 2 in b4 it is ='sheet1'!d12-'sheet1'!c12. It gives me 11:00 cool yep 11 hours indeed.
Now on sheet 2 i need to multiply the hours by their wages. So on sheet 2 i have =sum(b4*$j$4). J4 is their wage. So it ends up trying to multiply 11:00×$15.35 amd gives me $7.04 instead of what it actually is $168.85. How do i fix this?
Now on sheet 2 i need to multiply the hours by their wages. So on sheet 2 i have =sum(b4*$j$4). J4 is their wage. So it ends up trying to multiply 11:00×$15.35 amd gives me $7.04 instead of what it actually is $168.85. How do i fix this?