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). |
=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). |
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). |
All times are GMT +1. The time now is 01:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com