| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ref earlier post "Excel Time Calculation"
For the formula in D2 "=C2-time(,50,) with no time in cell C2, can the
default value ####### be changed (to zero (0) or a blank cell) Regards jc |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ref earlier post "Excel Time Calculation"
Try this:
=IF(C2=0,0,C2-time(,50,) Change the second 0 to "" if you want it to appear blank. Hope this helps. Pete On Nov 7, 6:14 pm, jc wrote: For the formula in D2 "=C2-time(,50,) with no time in cell C2, can the default value ####### be changed (to zero (0) or a blank cell) Regards jc |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ref earlier post "Excel Time Calculation"
Try
=MAX(C2-TIME(,50,),0) it's important that you format D2 as hh:mm:ss or hh:mm otherwise it defaults to AM/PM formatting and 0 will be returned as 12:00 AM -- Regards, Peo Sjoblom "jc" wrote in message ... For the formula in D2 "=C2-time(,50,) with no time in cell C2, can the default value ####### be changed (to zero (0) or a blank cell) Regards jc |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ref earlier post "Excel Time Calculation"
Sorry, bracket missing from the end of my formula:
=IF(C2=0,0,C2-time(,50,)) Pete On Nov 7, 7:03 pm, Pete_UK wrote: Try this: =IF(C2=0,0,C2-time(,50,) Change the second 0 to "" if you want it to appear blank. Hope this helps. Pete On Nov 7, 6:14 pm, jc wrote: For the formula in D2 "=C2-time(,50,) with no time in cell C2, can the default value ####### be changed (to zero (0) or a blank cell) Regards jc- Hide quoted text - - Show quoted text - |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ref earlier post "Excel Time Calculation"
Magic formulas. All sorted now. Thanks Pete & Peo.
I'm sure I'll be back with other questions. jc "Peo Sjoblom" wrote: Try =MAX(C2-TIME(,50,),0) it's important that you format D2 as hh:mm:ss or hh:mm otherwise it defaults to AM/PM formatting and 0 will be returned as 12:00 AM -- Regards, Peo Sjoblom "jc" wrote in message ... For the formula in D2 "=C2-time(,50,) with no time in cell C2, can the default value ####### be changed (to zero (0) or a blank cell) Regards jc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a "one time only" calculation field? | Excel Worksheet Functions | |||
| "Disk is Full" add-on question to "Can't reset last cell" post tod | Excel Discussion (Misc queries) | |||
| Incompatible "allow users to edit range" in earlier Excel versions | Excel Discussion (Misc queries) | |||
| I'm desperate I posted earlier about "If" statements that don't work but are correct. Now... | Excel Worksheet Functions | |||
| Should I generally request "post a poll" when I post a new thread? | Excel Discussion (Misc queries) | |||
Linear Mode
