# how to multiply h:mm value by an hourly \$ rate

1. ## how to multiply h:mm value by an hourly \$ rate

Entering time values in custom format [h]:mm:ss
Cells accept hours over 23,
Adding cells in column returns correct total time.
Have not found a way to multiply these cells by a \$ hourly rate.
So use HOUR(cell ref) and MINUTE(cell ref) to capture values in referenced
cell - then use these values to calculate total payment for \$rate per hour.
However, the HOUR(cell ref) formula returns the hours in excess of 24 when
the cell contains an hour value in excess of 23 (ie 27 hours returns 3).  Register To Reply

2. Hi,

Excel uses decimal numbers to represent date/time. The integer part is the number of days starting from 1/1/1900 and the decimal part is a fraction of a day. I.e. 0.5 means 12 hours and in your example 27 hours = 1.125.

Now let's say you use an hour rate of \$20 and you have to calculate it for 27 hours. Use the following formula:

=<time>*<rate>*24 => =<27 h>*<\$20>*24 => =1.125*20*24 = \$540

Just remember to reformat the cell where the answer will be.

- Asser  Register To Reply

3. ## Re: how to multiply h:mm value by an hourly \$ rate

=TotalTime*24*HourlyRate

Johstra wrote:
> Entering time values in custom format [h]:mm:ss
> Cells accept hours over 23,
> Adding cells in column returns correct total time.
> Have not found a way to multiply these cells by a \$ hourly rate.
> So use HOUR(cell ref) and MINUTE(cell ref) to capture values in referenced
> cell - then use these values to calculate total payment for \$rate per hour.
> However, the HOUR(cell ref) formula returns the hours in excess of 24 when
> the cell contains an hour value in excess of 23 (ie 27 hours returns 3).
>  Register To Reply

4. ## RE: how to multiply h:mm value by an hourly \$ rate

try =(DAY(A6)*24+HOUR(A6)+MINUTE(A6)/60)*HR

"Johstra" wrote:

> Entering time values in custom format [h]:mm:ss
> Cells accept hours over 23,
> Adding cells in column returns correct total time.
> Have not found a way to multiply these cells by a \$ hourly rate.
> So use HOUR(cell ref) and MINUTE(cell ref) to capture values in referenced
> cell - then use these values to calculate total payment for \$rate per hour.
> However, the HOUR(cell ref) formula returns the hours in excess of 24 when
> the cell contains an hour value in excess of 23 (ie 27 hours returns 3).
>  Register To Reply

5. ## Re: how to multiply h:mm value by an hourly \$ rate

=(time-int(time))*24  Register To Reply

6. ## Re: how to multiply h:mm value by an hourly \$ rate

Try this, A1 is time
=int(A1*24)*hourrate  Register To Reply

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1