| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date calcuation (another)
Widget A operates 24/7 until failure. The time is in 24 hr format. Need to
substract C2 from D2 to get E2 (same format). I've tried several functions and examples from the Discussion Groups. However; I need to see the (a) correct answer for validation -- I get confused easily... A B C D E 01 Equip RunTime EndDate&Time StartDate&Time 02 Widge A 8,939.9 03/15/08 12:54 ??/??/?? ??:?? 03 04 ShagNasty... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date calcuation (another)
If RunTime is in hours then one way:
E2: =D2 - C2/24 Format E2 the same ad D2. In article , ShagNasty wrote: Widget A operates 24/7 until failure. The time is in 24 hr format. Need to substract C2 from D2 to get E2 (same format). I've tried several functions and examples from the Discussion Groups. However; I need to see the (a) correct answer for validation -- I get confused easily... A B C D E 01 Equip RunTime EndDate&Time StartDate&Time 02 Widge A 8,939.9 03/15/08 12:54 ??/??/?? ??:?? 03 04 ShagNasty... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiplicative calcuation | Excel Discussion (Misc queries) | |||
| Date Calcuation with Blank Cells | Excel Worksheet Functions | |||
| If And Calcuation | Excel Worksheet Functions | |||
| Disalbe the Calcuation in Excel after vaildety date | Excel Worksheet Functions | |||
| holding a value after first calcuation | Excel Worksheet Functions | |||
Hybrid Mode
