convert Time into Dollars

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

simple question but I don't know the answer...I'm tracking
my hours and I need to convert total hours into a dollar
figure.

here is an example of my problem:

B2: =time(8,0,0)
C2: =time(3,45,0)
D2: =+(C2-B2) with the column in time format [H]:MM
E2: $10.00 (my rate in currency format)
F2: ???my total in dollars per my rate???

If anyone can help that's be great...
 
Hi Daniel

Multiply elapsed time by 24 * hourly rate.

Since time is recorded as a decimal part of a day you need to convert
it to hours.

Your =+(C2-B2) won't work except with a 1904 date system setting
(Under Tools > Options > Calculation) and even then it will return a
negative.

General form for times entered in a form recognised as time:

=EndTime-StartTime
Format hh:mm

But if the times can span midnight use:

=(EndTime-StartTime+(EndTime<StartTime))

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top