That approach was for use in conjunction with Custom Format approach, if using formula I would opt for:
=IF(MOD(G91-F91,1)<=0+"00:30","ONTIME",MOD(G91-F91,1)-"00:30")
change the "00:30" to be whatever time span you want (but yes in essence the value provided was a rough representation of 30 mins in numerical terms, 24 hours = 1)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
oh i see...thanks for letting me know about that..i was not aware of it...thanks again...i appreciate your timely response...
cheers!
stoey
oh by the way donkey last follow up question...sorry about this but how do i go with the formula such that if cell A and B are blank then cell C is blank also using the formula
=IF(MOD(B1-A1,1)<=0+"00:30","ONTIME",MOD(B1-A1,1)-"00:30")
...if there would be value on cell A but not on cell B then C is still blank.
if there would be value on cell B but not on cell A then C is still blank.
however if A and B have values then C values appears...
sorry for all the hassle...thanks a lot
regards,
stoey
You can use a COUNT test given both A & B should be numeric, ie:
=IF(COUNT(A1:B1)=2,IF(MOD(B1-A1,1)<=0+"00:30","ONTIME",MOD(B1-A1,1)-"00:30"),"")
hi donkey,
thanks a lot! worked like a charm! thanks again...
Regards,
stoey
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
stoey 
Register To Reply
Bookmarks