Forum Discussion
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 calculation for the cost.
Would like the decimal value for time in the first empty column.
I can then multiply the time by the cost.
Or in one formula do the conversion and multiplication
Many thanks for your replies
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.
2 Replies
- Aruna_TelshanCopper Contributor
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.