Forum Discussion
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) ...
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)
- I just realized this only works if the total hours worked doesn't exceed 24?
Please apply custom format (Ctrl+1) as [hh]:mm for the elapsed time.
