| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need excel formula to calc time i.e.08:29:29am-23:21:32pm=9:07:57
I need to determine the amount of time a process took. It begain at
23:21:32pm and finished at 8:29:29am. The total time = 9:07:57 (9hrs 7min 57sec). I need a formula to calculate the total time. The formual I tried =text(b10-b9,"h:mm:ss") and that produced #VALUE!. I changed to the 1904 date system under tools/options/calculation and that produced -14:52:03. If I could convert that negative to a positive from 2400 hrs then I would have the correct answer. Any insight would be greatly appreciated.... please and thank you. :) I'm using excel 2003 microsoft office professional edition. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time calc formula please. | Excel Discussion (Misc queries) | |||
| Excel Template: calc time per task fr 'start' and 'end' times | Excel Worksheet Functions | |||
| Excel Formula to Calc Daily Averages? | Excel Worksheet Functions | |||
| formula that calc the diff in time, with a less than function? | Excel Worksheet Functions | |||
| The Excel cells are not automatically calc. existing formula. | Excel Worksheet Functions | |||
![doodlebug[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
