| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
I suspect that your Hours Worked is really an Excel time value that is
formatted to look like 4 hours. When you divide 200 by 1200 you get 0.166666, which is the decimal equivalent of 4 hours/24 hours in a day. To get what you are looking for use the a formula that does this: $200/(Hours Worked x 24): =A1/(A2*24) Does that help? Regards, Ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time formula | Excel Discussion (Misc queries) | |||
| Excel Miscalculates simple formula..Help!! | Excel Worksheet Functions | |||
| Formula for time | Excel Discussion (Misc queries) | |||
| Formula for time? | Excel Discussion (Misc queries) | |||
| What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
Threaded Mode
