Need help getting rid off #VALUE! error in time calculations when using text on cells.

[tazmtiger]

Hi

I am working on a work schedule with time calculations and I am using text in some cells, but this creates a #VALUE! error in the summary line. Can some one please help me find a solution using the two folowing formula lines:

AY =((D12-INT(D12))*24)-((C12-INT(C12))*24)
BA =IF(AY24<0,24+AY24,AY24)

Thank you!

 

[Jonmo1]

Ok, well I was kinda just humoring myself in expanding and re-expanding...
But now it's getting out of hand..

You'd probably be better of designating 2 other cells for these text entries, and letting C12 and D12 be Time or blank only.
Let E12 (and ONLY E12) be used for Off or Close
Let F12 (and ONLY G12) be used for the designated Hour of Close (6.5 7 or 8)
Then you can do
=IF(E12="Off",0,IF(E12="Close",F12,IF(COUNT(C12:D12)=2,((D12-INT(D12))*24)-((C12-INT(C12))*24),0)))