Home > Forum Home > Developing Business Administration Solutions > IF Formula to calculate actual time*cost ? Share

IF Formula to calculate actual time*cost ?

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


Forum TopicPost Reply Login

If Formula To Calculate Actual Time*cost ?

Rate this:
(3/5 from 1 vote)
ConfusedHi,

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 on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Oops
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 on
 Displaying page 1 of 1 

Excel templates and solutions matched for IF Formula to calculate actual time*cost ?:

Solutions: File Comparison Bar Code Generator Spreadsheet Auditing Spreadsheet Link Checking Input Cell Solver Formula Analyzer Formula Auditing