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

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!


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=114346

Thank you jamexcox. That did it perfectly!

"jamescox" wrote:


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!


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=114346