Comparing two times (HH:MM:SS)

  • Thread starter Thread starter CopperNic
  • Start date Start date
C

CopperNic

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
 
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=g:thl1703716756d&[email protected]

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
 
Back
Top