Time Extraction In Minutes

[David M]

This one is hard to explain but I will give it a shot...

I have a start time and an end time of an incident...lets
say the start time is 1:40am and the end time is 2:40am....

My maintenance window of time is 1:00am to 2:00am...so in
this case that leaves 40min of time I need to actually
account for....this amount will equal and outage...

I need to be able to extract that 40mins, and count that
into my minutes formula which is =(((E31+F31)-(C31+D31))
*1440)

So the result would be 40mins instead of 60min giving me
the real outage time for that incident.

Currently in these cases, I have to do this manually by
changing the times to reflect the actual.....

Hard One???

 

[Trevor Shuttleworth]

David

I'm confused as to which cells hold which values. From what you have
described, surely all you need to do is take the support time end from the
incident time end to get your outage. The start of support time and start
of incident time seem to be irrelevant.

C31 = ?
D31 = ?
E31 = ?
F31 = ?

Regards

Trevor

 

[David M]

I can calculate the outage time but if the times are from
lets say 1 to 2-40....one hour of the time does not
matter..only the 40 minutes matter and I would like to be
able to haev excel falg times that fall within the 1-2
range and if it goes over lets say by 10 min...I need to
take only the tem min and facter that as the outage time
for that incident...

D