Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate sum based on 3 conditions? | Excel Worksheet Functions | |||
How do I calculate interest and deduct late fees based on date pa. | New Users to Excel |