Adding or combining time problem.
I am trying to simply add times h:mm format.
=TEXT(F22-"37:30","h:mm")
=TEXT(F49-"37:30","h:mm")
These can and do give negative results because I am using the 1904 date
system.
But, if I try to sum the result of these two if any have a negative result I
get an error. I am using the below for the sum:
=F23+F50 all h:mm
So how do I add values when one is negative? Or is there another way?
Thanks!
|