Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Hours * Currency

Status
Not open for further replies.

nberryman

Instructor
Jun 1, 2002
556
GB
I can calculate the hours worked from start and end times but how do I multiply the hours worked by the cost per hour?

I have dome this before but I think my age is catching up with me

Many thanks



Neil Berryman
IT Trainer
neil_berryman@btopenworld.com
 
If your hours worked are in proper time format then
=(Hours worked * 24) * Rate Per Hour
should work for you


Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
 
Many thanks, I will give that a go

Neil Berryman
IT Trainer
neil_berryman@btopenworld.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top