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