Date calcuation (another)

  • Thread starter Thread starter ShagNasty
  • Start date Start date
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...
 

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
Adding up time values 11
Date ranges 1
Copy value according to date 1
Date Function 2
Modifying a complex date formual to count months 4

Back
Top