setting up an invoice in excel

K

Kelly H

does anyone know how to set up an invoice in excel so that i can put "start
time" and "end time", have excel subtract start from end to get a total and
then multiply it by an hourly rate? it seems like this should be easy but i
can't figure it out.
 
F

Frank Kabel

Hi
if A1 and A2 contain your start/end times and C1 your hourly rate use:
=(A2-A1)*24*C1
and format this cell as number
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Style to 'Keep with previous' instead of Keep with Next 1
Look Up Formula With Veried Search Range 2
Wrapping and Anchors 0
VBA word change keys 0
Invoice Templates 0
Creating backgroound for an Invoice 1
how can i set up changing invoice numbers in excel? 1
VBA works in orignal but fails in copy of database 1

Top