Date calcuation (another)

S

ShagNasty

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...
 
J

JE McGimpsey

If RunTime is in hours then one way:

E2: =D2 - C2/24

Format E2 the same ad D2.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

separating date and time 5
Subtracting time...again 2
Conditional Time Calculation 10
Modifying a complex date formual to count months 4
Copy value according to date 1
Multiple Creteria Lookup(Between Dates) 8
Date Function 2
Adding up time values 13

Top