Forum Discussion
Formula help
OK, I've updated the formula in the workbook to lookup the accident number instead of the accident type.
Regards
I' trying to get it to where I just input my time in/time out and it calculate the hour and then total across where it says hours worked then total across the bottom. Thanks
Hi Jeremy,
Formulas in cells D14 to J14 are works just fine!
To get the correct to total in cell K21, all you have to do is to multiply the total by 24 as follows:
=TEXT(SUM(D21:J21)*24,0)
NOTE: I've used TEXT function to overcome an issue that may set back the format to the time format.
You can also change the time format of cell K21 to get the correct total and keep it in time format as the below screenshot:
Please find the attached file.
Regard,
Haytham
Thank you Sir. Is there anyway to have the totals correspond as on the tab at the bottom "Hours Converted" so that say on D21 10:15 translates to 10.25?
Of course, you do that.
Just change the formula in cell D21 to this:
=TEXT(D14*24,"0.00")
And then, copy it to the right until cell J21.
After that, use this formula in cell K21 to get the total.
=SUMPRODUCT(VALUE(D21:J21))
Please find the attached file
AGAIN!, I say thank you sir.