Comparing two times (HH:MM:SS)
 

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

Comparing two times (HH:MM:SS)
 

I attempted something similar a few weeks back.

As it worked out, the time formula became a lot more complicated because we
were dealing strictly with time, not dates.
Ask yourself, can the downtime cross midnight. 23:00 - 02:30 appears to
end before it started.

http://groups.google.co.nz/groups?q=...280a%40phx.gbl

I've implemented a downtime application. I suspect though what you really
want to be reporting is uptime.

If you can guarantee that the downtime start and end times are after
eachother (and not like my example above), then you just use
min(downtime_end, closetime) - max(downtime_start, opentime)

Rob



"CopperNic " wrote in message
...
Hello all,

I looking for some help in comparing two seperate times in excel. This
will be used to compare network down time to operation hours. I need
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.

Thanks

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