Forum Discussion
Solved
Help with formulas
Good afternoon guys. I am looking for help with formulas for a time sheet. I need to be able to convert time values from the xx:xx:xx (first column) format to decimal to use a multiply calculati...
Assuming that you want to convert to decimal hours, multiply with 24.
So in a cell in row 2
=A2*24
and format the cell with the formula as General or as Number, or use
=A2*24*C2
and format the cell with the formula as Currency.
