Forum Discussion

robindspain's avatar
robindspain
Copper Contributor
Mar 26, 2023
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 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

  • robindspain 

    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

  • robindspain 

    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.

Resources