Time calculation: billing for minutes

  • Thread starter Thread starter KENNY STURM
  • Start date Start date
K

KENNY STURM

I am trying to enter a start time in one cell, an end time in another, and
calculate the total to charge, based on $35 per hour. ie: 9:35 a.m. start,
9:40 a.m. end is 5 minutes. How do I calculate 5 minutes (1/12 of an hour)
into percentage, or whatever to end up with the correct answer. (I should
come up with $2.92)

I'm feeling pretty stupid right about now.
 
Hi Kenny,

B23: 09:35 C23: 09:40 D23: 00:05 E23: $ 2.92
B23: 0.39930 C23: 0.402777 D23: =C23-B23+(B23>C23) E23: =D23*24*35
h:mm h:mm h:mm _($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)

Subtract starting time from ending time (adjust if ending time earlier than start time)
Multiply difference by 24 hours to convert fraction of day to hours
and multiply by $35/hour

More on date and time in
http://www.mvps.org/dmcritchie/excel/datetime.htm
 
Back
Top