hi there, im in a stick n puzzled
want excel to calculate difference between 2 cells data in 1 row
e.g a1 12:00 b1 14:00 c1 = b1 minus a1 therefore 2:00
but when b1 = 02:00 then c1 = -10:00 but obviously i want to be 14 hrs
please note i have the cells custom format ##\:00 so a user just enters 1200 and the colon gets put in.
this is obviously a simple task however i cant think for the life of me
want excel to calculate difference between 2 cells data in 1 row
e.g a1 12:00 b1 14:00 c1 = b1 minus a1 therefore 2:00
but when b1 = 02:00 then c1 = -10:00 but obviously i want to be 14 hrs
please note i have the cells custom format ##\:00 so a user just enters 1200 and the colon gets put in.
this is obviously a simple task however i cant think for the life of me