can anyone help with this timesheet problem please ?
A1 is a variable time value
,B1 is a time value containing =SUM(A1-C1)
C1 is a constant time value of 7:24 all formated as hh:mm
What i would like to do is display B1 as empty or as 00:00 when A1 is 00:00
or below.
oh and thanks to the people who helped with the question i posted yesterday!