convert a time duration to a number to use in a formula

[jdaich]

My issue is this, I have calculated a time duration using two different time periods and have for example 2 hours. I want to multiply this by a dollar amount for example $20. When I perform the calculation the resulting amount is not correctly calculated. I calculated a time from 1:00 pm to 3:00 pm and this resulted in 2 hours. the columns are formatted as "time" format. I then multiply this by $20 and my result is $1.67. If I change the answer to a date format it calculates to 4:00:00 pm. which is not what I am looking for.

[mehmetcik]

=(hour(B1)-hour(A1))*20

[Greg M]

Hi there,

If you're dealing with times which have hour and minute values you could use:

Please Login or Register  to view this content.

where the starting time is in Cell A1 and the finishing time is in Cell B1.


Regards,

Greg M



P. S. Although a cell containing a time value of one hour may be formatted to display 01:00, it actually contains a numerical value of 1/24