| Home > Forum Home > Developing Business Administration Solutions > IF Formula to calculate actual time*cost ? > Time function with multiplier | Share |
Time function with multiplier
Excel Help for Time Function With Multiplier in Developing Business Administration Solutions
| Forum Topic | Login |
Time Function With Multiplier | Rate this: (3/5 from 1 vote) |
 | If the time entered is in date/time format you get the number of hours by using the =HOUR(value) function. If you have a 15 minute price then you can simply divide the hours by 4 and multiply by the price. If you have multiple prices depending on time taken, then you can pass the time taken in a lookup function to get the rate and then multiply. | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
Excel templates and solutions matched for Time function with multiplier:Solutions: Data Cleansing Work Efficiency Add-ins |