Excel Equations/Formulas

02/23/2009 11:09 AM

Hi,

i have a report format as shown below. Kindly educate me on the following,

1. How to calculate Alarm duration i.e the difference of Alarm End Date/Time (Cell:G2) and Alarm Start Date/Time (Cell:F2)

2. Percentage of daily outage i.e Value of Alarm Duration (Cell:H2) in seconds divided by 24x60x60 seconds x 100%

3. Date/Time format for F and G will be 3/14/01 13:30 i.e (Date Time)

1	A	B	C	D	E	F	G	H	I	J	K
2	Site ID	Site Adress	Region	Date	Alarm status	Alarm Start Date and Time (Date, Hours:Min)	Alarm End Date and Time (Date, Hours:Min)	Alarm Duration (Hours:Min)	Remarks	% outage per day	% power unavailabilty per week

Thanks as you assist

Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

Graebeard Power-User Join Date: Aug 2007 Location: Toronto Posts: 239 Good Answers: 9	#1 Re: Excel Equations/Formulas 02/25/2009 2:23 PM
	Well, aside from the basic math which should be self-evident, what I would suggest is setting your date and time formats to something like d/m/yyyy hh:mm for the start and end times, then doing the math, then setting the resulting format to just m/d hh:mm The Alarm Duration will then show up as month/day hours:minutes
	Reply

	Got Something to Say?
	Ask a Question Start a Discussion

	Aerospace
	BioMech & BioMed
	Chemical & Material Science
	Civil Engineering
	Communications & Electronics
	Education and Engineering Careers
	Electrical Engineering
	General Discussion
	Instrumentation
	Manufacturing
	Mechanical Engineering
	New Technologies & Research
	Software & Programming
	Sustainable Engineering
	Transportation

	Site Directories
	Forum Directory Blog Directory User Group Directory RSS Feeds CR4 Rules of Conduct CR4 FAQ Site Glossary Who's Online (85 right now) Show Members