IF Formula to calculate actual time*cost ?

Excel Help for If Formula To Calculate Actual Time*cost ? in Developing Business Administration Solutions

If Formula To Calculate Actual Time*cost ?

Rate this: (3/5 from 1 vote)

	Hi, I need some help working out how i can get my spreadsheet to understand that working for 15 minutes would be one price working for 30 mins would be double that price, this is for a company work log so the user would select i.e 1 hour in time taken and the total would calculate the cost. Thanks  Customer Date Worker Product Time Taken Total (excl VAT) Invoice Number Customer History Nick Keyword Research 45.00 £24.00   Title Tag Optimization 30.00 £24.00 Setting Up Twitter 15.00 £50.00 Setting Up Facebook 2.00 £75.00 £173.00 Andrew 1 x traffic building and co.uk domain 3.00 £44.99 1 x traffic building and co.uk domain £44.99 1 x text link advert for 1 year £120.00 Content Optimization £144.00 £353.98 Mark 1000 Backlinks £30.00 Online Stats Report £10.00 1000 Backlinks £30.00 Free One Page SEO Knowledge £10.00 £80.00 Vitrani Keyword Research £24.00 Online Stats Report £10.00 Directory Submissions £144.00 1000 Backlinks £30.00 £208.00 Outsource 1000 Backlinks £30.00 £30.00 Anthony Free One Page SEO Knowledge £10.00 1 x text link advert for 1 year £120.00 Robots.txt Optimization £6.00 Setting Up Facebook £75.00 £211.00
	CLO
	Posted by Charlotte on 16 Jun 2011

Replies - Displaying 1 to 1 of 1

Order Replies By: Most recent | Chronological | Highest Rated

	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 16 Jun 2011

Displaying page 1 of 1