1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

  3. 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

Discussion in 'Excel Dashboards' started by dieselkhan, Dec 18, 2018.

  1. dieselkhan

    dieselkhan Member

    Messages:
    315
    Want to know Delay minutes. please any one can help me out

    Attached Files:

  2. AliGW

    AliGW Active Member

    Messages:
    318
    Try this:

    =IF((E2+F2)-(C2+D2)<0,"No Delay",(E2+F2)-(C2+D2))

    Set the cell formatting to:

    [mm]:ss

    Attached Files:

  3. dieselkhan

    dieselkhan Member

    Messages:
    315
    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
  4. AliGW

    AliGW Active Member

    Messages:
    318
    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.
  5. dieselkhan

    dieselkhan Member

    Messages:
    315
    Please find the attached file

    Attached Files:

  6. AliGW

    AliGW Active Member

    Messages:
    318
    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.
  7. vletm

    vletm Excel Ninja

    Messages:
    4,642
    dieselkhan
    You sent same file ...
    those formats are not challenges...

    As AliGW , but the delay shows only minutes...

    Attached Files:

  8. dieselkhan

    dieselkhan Member

    Messages:
    315
    ops sorry
  9. AliGW

    AliGW Active Member

    Messages:
    318
    Yes, because you said this:
  10. dieselkhan

    dieselkhan Member

    Messages:
    315
    So if actual time is in AM thn DATE_SCHEDULED convert in am .. or actual PM and DATE_SCHEDULED is pm thn stay sa it is Thanks

    Attached Files:

  11. AliGW

    AliGW Active Member

    Messages:
    318
    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.
  12. AliGW

    AliGW Active Member

    Messages:
    318
    Sorry - I do not understand your data. I hope someone else will step in. Good luck!
  13. vletm

    vletm Excel Ninja

    Messages:
    4,642
    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!
  14. dieselkhan

    dieselkhan Member

    Messages:
    315
    thats manual i add and i need that output
  15. vletm

    vletm Excel Ninja

    Messages:
    4,642
    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?
  16. dieselkhan

    dieselkhan Member

    Messages:
    315
    see coloumn H .. i want this Output .. is there any formula.

    Attached Files:

  17. AliGW

    AliGW Active Member

    Messages:
    318
    How is Excel to determine whether the scheduled time in D is AM or PM?
  18. dieselkhan

    dieselkhan Member

    Messages:
    315
    this is the master File might b its help you

    Attached Files:

  19. vletm

    vletm Excel Ninja

    Messages:
    4,642
    dieselkhan
    If You don't want to help Yourself by giving any answer,
    then I can wish only 'Good Luck'.
  20. AliGW

    AliGW Active Member

    Messages:
    318
    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.
  21. dieselkhan

    dieselkhan Member

    Messages:
    315
    =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
  22. dieselkhan

    dieselkhan Member

    Messages:
    315
    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
  23. vletm

    vletm Excel Ninja

    Messages:
    4,642
    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!
  24. dieselkhan

    dieselkhan Member

    Messages:
    315
  25. vletm

    vletm Excel Ninja

    Messages:
    4,642
    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!

Share This Page