| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Sheets | Excel Discussion (Misc queries) | |||
| unmet challenge | Excel Worksheet Functions | |||
| I cannot get time format to display in a drop-down list | Excel Discussion (Misc queries) | |||
| entering numbers to display a time format | Excel Discussion (Misc queries) | |||
| Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions | |||
Linear Mode
