Excel invoice using labour charges based on date & time

In Progress

A simple little project for someone with excel knowledge, I have an excel spreadsheet template,

sheet 1 is a printable invoice,

sheet 2 contains data for UK VAT rate, product pricelist and labour charges.

Date & Time Pickers

On the invoice there needs to be a date and time selector for start and end time. This needs to the compare the dates and times against 3 different pricing bands Band A between 8:00 and 17:00 (mon - fri) Band B between 17:00 and 8:00 (mon - fri) and Band C Weekends & UK Bank holidays. Bank holidays may be a pain so it may need a selector to switch to band a/b/c rates aswell as the automatic one. Each price band needs a callout charge 1 off and then an hourly charge for time during that band, if it crosses bands for example late friday tosaterday morning it needs to charge two sets of hourly rates some at Band A some at Band C, hope that makes sense

Item selection

pull down boxes that select an item from the data sheet and fills in the prices in the invoice

Skills: Excel

See more: invoice labour charges, labour charge invoice, labour charges invoice, invoice excel labour charges, labour charges invoice excel, charge labour invoice, labour charge invoice template, excel hourly rate based time, excel based labour time sheet, invoice labour excel, invoice labour, invoice time labour, invoice template labour charge, invoice template labour, template pricelist, rate sheet template excel, project end time, product pricing spreadsheet, hourly invoice, excel hourly rate, excel invoice time, excel labour invoice, weekends off, vat charge, invoice template in excel

Project ID: #968686

Awarded to:

kanadyanako

Kindly read attached proposal.

£30 GBP in 0 days
(1 Review)
1.8

30 freelancers are bidding on average £47 for this job

bharanisrihari

Hi, Excel expert here. Ready to start ASAP. Please check PM for details. Thanks!

£45 GBP in 1 day
(57 Reviews)
6.3
vserv

Pls see your messages. Thanks

£30 GBP in 1 day
(53 Reviews)
5.6
vbexcel

Excel expert - ten years experience.

£45 GBP in 1 day
(25 Reviews)
5.2
SamNanton

See PM for details.

£40 GBP in 7 days
(25 Reviews)
4.9
best4best

I am an Excel expert. Please take a look at my reviews for Excel project. I can create the template to generate the invoice as per your specifications.

£30 GBP in 1 day
(55 Reviews)
4.9
wsh2

Greetings UK from the USA.. 20+year MsExcel business programming expert. Banding, excellent choice of words. Please see PMB. Respectfully, Bill.

£50 GBP in 999 days
(9 Reviews)
4.7
priyaam

Hi, I am interested in this project

£35 GBP in 3 days
(7 Reviews)
3.3
mantripti

Hi, I have a team support of a Mechanical Engineer, M Tech & MBA, Cost Management Accountant. I also have a team support of number of professionals, including IT engineers, Computer professionals. We are having exper More

£30 GBP in 1 day
(9 Reviews)
3.3
Shijidhar

Hai, I am ready to start. Please check OM. Thank you

£30 GBP in 1 day
(3 Reviews)
2.9
sTdwares

Hello. Please check your PMB before making a decision. I am sure you will be happy to work with me. Thanks (:

£50 GBP in 2 days
(1 Review)
1.6
bojan1979

Hello, I can do it, please see PMB

£30 GBP in 2 days
(1 Review)
1.0
brightspyredot

Please check PM

£30 GBP in 0 days
(0 Reviews)
0.0
adeelkhan700

interested in your project

£30 GBP in 0 days
(0 Reviews)
0.0
shahbaz04

i am civil engineer and i have the work experience in middle east

£30 GBP in 2 days
(0 Reviews)
0.0
kamal43

*Information Technology, Management Consultant* focusing on delivering Business/Office automation solutions with 20+ years of experience. Dear Sir, I have read the project posting and am submitting this proposal as More

£150 GBP in 5 days
(0 Reviews)
0.0
mohiuddin8214

i am ready for this job

£30 GBP in 3 days
(0 Reviews)
0.0
worker92

Hey i am an expert in EXCEL. Read PM

£40 GBP in 2 days
(0 Reviews)
0.0
rakibulhafiz

Dear Hiring manager., According to your advertisement I am very much interested in this job and I can Join in any time you will say.Because I think I have enough experience to work with you and I can dedicated more tim More

£30 GBP in 3 days
(0 Reviews)
0.0
ahsan1558

I will do it very easily as i have experience to do such type of work.

£50 GBP in 10 days
(0 Reviews)
0.0
dahane

Hello Sir, i'm ready to work. thanks

£30 GBP in 6 days
(0 Reviews)
0.0