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
 
Top