| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
need help with a simple time formula
I am trying to divide a days pay by hours worked to give a wage per hour
amount. ex. A1 $200.00 (days pay) A2 4:00 (Hours worked) A3 $50 ( I thought this should be =A1/A2) My problem is A2 is a calculated field and I am getting weird results like 1200. What am I doing wrong? Thanks for your help. |
| 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
