ExcelBanter - how do i display a time value conditionally

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i display a time value conditionally (https://www.excelbanter.com/excel-discussion-misc-queries/21227-how-do-i-display-time-value-conditionally.html)

stuck!

how do i display a time value conditionally

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!

JE McGimpsey

One way:

B1: =IF(A1<=0,0,C1-A1)

Note that your SUM() is superfluous.

In article ,
stuck! wrote:

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!

All times are GMT +1. The time now is 09:51 PM.