LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
glass-artist-web-developer
 
Posts: n/a
Default How do I calculate charges based on elasped time(H:MM) & rate($)?

How do I calculate charges based on elasped time & rate?

I want the time spent on a service to display in HH:MM

Then I want to multiple this elasped time by a rate, say $25/hour. I can
put this rate on the form and keep this cell outside the print area, or I can
type "25" into the fomula, either will work for me.

When I try to input a custom format, as described in help to be <h:mm
(where < are square brackets), the data input shows in the input field as
1:30 AM, even after deleting the "AM" part, so it refuses to treat this as
elasped time.

Please HELP!!!! I don't want to have to firgure the fractions of an hour
for each task in order to perform this calculation.

Thanks in advance
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I calculate sum based on 3 conditions? MNSNOWGAL Excel Worksheet Functions 4 January 19th 05 11:35 PM
How do I calculate interest and deduct late fees based on date pa. leon New Users to Excel 1 January 6th 05 02:09 PM


All times are GMT +1. The time now is 01:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"