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 |
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 |
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 |
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 - |
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 |
All times are GMT +1. The time now is 08:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com