Determining availability time

[Steve]

I need to determine how to subtract outage time from available time.

I have 4 columns with the following:

Outage Start Outage End Duration Available
17:00 17:25 00:25

What I want under Available is the duration subtracted from 75 hours but
cannot get that part figured out.

Any help would be greatly appreciated.

Thank you

Steve

 

[jamescox]

For your duration cell, use the formula:

=75/24-D8 (where D8 is your Duration cell's address)

then do a cell custom format of

[h]:mm

which will give you a value of

74:35

Good luck on your project!

 

[Steve]

Thank you jamexcox. That did it perfectly!