Forum Discussion

Copper Contributor

Mar 05, 2020

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) ...

excel

PReagan

Bronze Contributor

Mar 05, 2020

cbrigham

Or to make the # of hours worked more clear, the formula should be:

(C2-B2)*24

formatted as number or general

cbrigham

Copper Contributor

Mar 05, 2020

This works! Thank you.