Thanks a million!!!
--
Mark


"Teethless mama" wrote:

=B1-A1+(A1B1)


"Mark" wrote:

I have an instance where we are using excel to calculate work times however
on some calculations an error appears. I am told that excel does not calcuate
or recognize negative time differences. The formula that I am currently
using is A1-B1. Is there any way to over come this?

Time In Time Out Hours Worked
6:00 AM 6:30 PM ####
6:30 PM 6:00 AM 12:30

Thanks in advance for your help.
--
Mark