Home |
Search |
Today's Posts |
#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). |
#2
|
|||
|
|||
=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). |
#3
|
|||
|
|||
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Annual Percentage Rate | Excel Discussion (Misc queries) | |||
how do i multiply hours:minutes by a cash value? | Excel Worksheet Functions | |||
How do I multiply rate per hour by hours worked. | Excel Worksheet Functions | |||
multiply by actual number in cell | Excel Worksheet Functions | |||
Rate of return required formula | Excel Worksheet Functions |