• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Differnece Between Dates & Time

Hi ALi

there is the problem what i need in
DATE_SCHEDULED
if Actual date is 24 format then
DATE_SCHEDULED
will b also 24 format

at the moment
DATE_SCHEDULED
only showing PM which is wrong is there any way to add one more column and use if condition can you help me on this as im new in excel
 

AliGW

Active Member
Mock up manually what you want to see as results (the first ten rows will do) and post your sample workbook again.

What you are now saying seems to be different to the original request.
 

AliGW

Active Member
That's the same as before. You have not changed or added anything. What I have asked you to do is mock-up manually (that is, type in) at least 10 rows of data as you want it to look.
 

AliGW

Active Member
We are getting nowhere. It is of NO USE attaching a workbook that does not show what you want. Take a moment, please, to mock up ten lines of data manually showing EXACTLY what you want.
 

vletm

Excel Ninja
dieselkhan
Did You try to check #7 Reply - file?
... and no matter of any AM/PM, if times has written correct?
and
in the last file, You add one more column ...
if that column would need somewhere then only You could not that!
 

vletm

Excel Ninja
dieselkhan
1) Did You checked #7 Reply includes:
There are Your 'delays'... in G-column:
Screen Shot 2018-12-18 at 13.40.50.png

2) Yes, You added something ... but what then?
How did You get those ... values?
and
What would be connection with this case 'Differnece Between Dates & Time'?
With out clear information ... who else knows?
 

AliGW

Active Member
this is the master File might b its help you
It isn't me who is asking for help - it's you!

Just answer the questions directly if you want my help. If you don't answer my questions, then sorry, but there will be no help from me.
 
=IF(D2="","",IF(F2>(--"12:00 Am"),D2+0.5,D2))

im using this formula which work fine but when actual timing is AM and schdule time also AM its converting schdule time as PM which is wrong
 
How is Excel to determine whether the scheduled time in D is AM or PM?
its depend its mix ... so we need to look if Actual is PM and schedele Am then convert to actual PM or Am .. if actual and schhudel is AM or PM so stay as it is


sorry my english is not good
 

vletm

Excel Ninja
dieselkhan
If You know that something is 'wrong' then
why do You send 'wrong information' here?
'Want to know Delay minutes.'
I want correct information and
if Your 'master File' would have correct file then try to use that!
 

vletm

Excel Ninja
dieselkhan
Excel won't use/understand negative time.
If that 'raw'-data is correct then Your s-column-'formula' not work!
There are 1048575 rows data ... I won't use formulas!
 
Top