Hello all,

I looking for some help in comparing two seperate times in excel. Thi
will be used to compare network down time to operation hours. I nee
help calculating the down time.

eg 1.

A1 Down from 07:00:00
A2 Restored at 08:00:00

A3 Open Hours 7:30:00
A4 Closed Hours 17:00:00

down time = 7:30:00 - 8:00:00 = 00:30:00

eg 2.

A1 Down from 05:00:00
A2 Retored ar 16:00:00

A3 Open Hours 07:30:00
A4 Close Hours 17:00:00

down time = 07:30:00 - 16:00:00 = 08:30:00


Any help would be appreciated.

Thank

Attachment filename: time calculation.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=40059
--
Message posted from http://www.ExcelForum.com