View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
purtech
 
Posts: n/a
Default 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!