Thread
:
How can I add hours and minutes then multiply by cost per hour?
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
Posts: n/a
How can I add hours and minutes then multiply by cost per hour?
Just put the times like start 08:00 AM end 05:00 PM for instance in A1 start
and B1 end
then
=B1-A1
then total at the end of the week or whenever
=SUM(C1:C5)
format as [hh]:mm
then finally multiply with 24 and the payrate
=C2*24*Pay_Rate
and format as currency or general
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
"Tom DiBell" <Tom
wrote in message
...
I'm a handyman who works on many apartments and homes and many little
projects within those places. I need to let the real estate firm know
what I
did and how long it took to do it. I need to put together a time sheet
showing what time I started a project and what time I ended that project.
A
column with the total number of hours and minutes after that. A total
number
of hours and minutes at the bottom of that column. And a total cost for
the
hours worked. I need a column with description of what I did and then at
the
very bottom a total for the entire job. Does anyone have any idea how I
can
do this? I've tried and failed miserably, and I thought I was pretty
advanced in the use of Excel! So now I ask, rather, beg for help.
Anyone????
Reply With Quote