Time formula

  • Thread starter Thread starter kenp
  • Start date Start date
K

kenp

I am trying to create a formula wherein I can enter time started, 1:00:00 and
time finished, 2:00:00, and then multiply this total by a dollar fee. Any
help would be appreciated
 
If your dollar rate in B1 is per hour, and your start and finish times in A1
and A2, then =(A2-A1)*24*B1
Format the result as General or Number, not as Time.
 

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

Determine if night shift by start & end time 2
TIME SHEETS 1
Subtraction formula with Text error 7
formula for shifts from times 2
Calculating Times for Pay Rates 4
Time calculations for Scheduled Time vs. Actual Time Worked 1
Time calculations for Scheduled vs Actual Employee Time and Wages 2
Time calculations for Scheduled vs Actual Employee Time and Wages 4

Back
Top