Comments on: Excel time format: 12/24 hour, custom, default

Microsoft Excel has a handful of time features and knowing them in depth can save you a lot of time. To leverage powerful time functions, it helps to know how Excel stores times. Continue reading →

Comments page 3. Total comments: 165

  1. I want the negetive time to show as ZERO when subtracting the time..
    23:40 - 23:30 = ##### instead of that i want it to be 00:00

    1. Hi Ali,

      You can use a formula similar to this:
      =IF(B2-A2<=0, "00:00", B2-A2)

      1. HI Madam
        Please help me actually i want to use a formula for my office which is very important for me. I want to calculate time like 02.30 to 3.10= 00.40, +13.30 to 14.00= =00.30 thier sum as 01.10 hrs in ecxel but i m unable to do the same.
        plz provide ur mail so i can send u excel sheet.
        Plz help
        regards
        Anil chopra +91-9992318962

      2. Hi madam,

  2. 48 hours example

    1. Hi Anant,

      Sorry, I am not sure I can follow you. Could you elaborate a bit?

Post a comment



Thanks for your comment! Please note that all comments are pre-moderated, and off-topic ones may be deleted.
For faster help, please keep your question clear and concise. While we can't guarantee a reply to every question, we'll do our best to respond :)