Forum Discussion
cbrigham
Mar 05, 2020Copper Contributor
Help calculating total hours worked times hourly rate
I'm trying to calculate total hours worked D7 x 14 (hourly rate) and have the $ amount result appear in E7 Date In Out # of Hours $14/hour 43892 0.375 0.697916666666667 =(C2-B2) ...
SergeiBaklan
Mar 05, 2020Diamond Contributor
It's not clear where are D7 and E7, but it looks like in E7 it shall be
=D7*24*14
(1 hour in time format = 1/24 as the number)
cbrigham
Mar 05, 2020Copper Contributor