how do i display a time value conditionally

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
One way:

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

Note that your SUM() is superfluous.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtraction formula with Text error 7
To Display Negative Dates 2
display time in IST as well as GMT? 5
Conditional Time Calculation 10
Pivot table macro filter data between yesterday and today (date+time) 0
Time Calculations 1
Time Calculations Help 4
How do i Calculate minutes between two different dates 5

Back
Top