google-sheetstimecurrencycalculation

Google Sheets time and currency calculations issue

In Google Sheets, is there a way to multiply time values with currency values? Current result doesn't work.

In other words,

Multiply hours(A) * dollars(B), result display in dollars(C) enter image description here

What's the syntax to write this kind of matching?

Thanks in advance!

Solution

  • Retrieve the total number of hours in B2 by using a combination of DAYS (for the number of full days passed, which you have to multiply by 24 to get the hours) and HOUR (for the hours passed in the last -nonfull- day):

    DAYS(B2,)*24+HOUR(B2)

    Then you can multiply that by B4:

    =(DAYS(B2,)*24+HOUR(B2))*B4

    enter image description here