| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculations on Times Formatted as Text
I would like to calculate the expense associated with the time usage of
something, given a rate per hour, and times formatted as Text such as below: 1535 1700 1535 represents 3:35 pm, and 1700 represents 5:00 pm. I can calculate the difference between the two, and get 3:25 for example, but not sure how to express/format this to get the desired 3 & 25/60 hours times "x" rate. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count text appear how many times & put in respec col??eg 1st times | Excel Discussion (Misc queries) | |||
| Calculations using Times in Excel 2003 | Excel Worksheet Functions | |||
| times and Calculations | New Users to Excel | |||
| Difference in dates calculations except between certain times. | Excel Discussion (Misc queries) | |||
| Converting 'General' formatted cells to Text formatted cell using. | Excel Worksheet Functions | |||
Threaded Mode
