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.
cbrigham
Copper Contributor
Mar 05, 2020
PReagan

When I tried that formula the result is in Military Time which unfortunately is confusing to some here in the states. 🙂 Is there a way to remedy that?