How about

=D40-IF(LEFT(D56,1)=":","0"&D56,D56)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jimmydageek"
wrote in message
...

I am not too worried about it as it is working now but yes there would
always either be a number or an N/A in there.

I posted another question similar to this but not getting much response
too. Here is my problem.

I have a report I put out and need to get the difference between the
two cells. The report populates the times in the following formation
:20:30. It does not put anything in the hour field when you pull the
report if it does not go past an hour of time.

I get an error trying to get the day before stats difference from the
present days stats. No formatting works. And there are way too many
fields to go in and manually enter a 0 for each cell that does not
contain an hour.

Thoughts?


--
Jimmydageek
------------------------------------------------------------------------
Jimmydageek's Profile:
http://www.excelforum.com/member.php...o&userid=31692
View this thread: http://www.excelforum.com/showthread...hreadid=513933