Forum Discussion

Marcel Gérin's avatar
Marcel Gérin
Copper Contributor
Jan 30, 2018

Time worked calculated. EX: 47,59,00 X $25 = 1224:35:00

47:59:00 X $25 = 1224:35:00         i want in $

3 Replies

  • Hi Marcel,

     

    In Excel time equivalent is number where 1 Hour = 1/24 (or 24 hours in one day). What you need to do is to multiply your hours on 24, after that on rate and apply currency format to the result, like

    =A1*24*25

    if hours are in A1 and 25 is your rate. If step by step then like

  • Thanks Dean!

     

    Yes, I'm moving your question to the Excel space for better visibility.

  • Dean_Gross's avatar
    Dean_Gross
    Silver Contributor
    I would recommend that you repost your question in one of the application specific community spaces. That is where it will be seen by people with the appropriate expertise.

Resources