How to subtract two date and time fieds in excel [duplicate]












-3
















This question already has an answer here:




  • subtract datetime in excel

    2 answers




I have two fields having date and time like: 11/08/2018 12:04 and 11/8/2018 12:00. I want Excel to subtract these fields and return me a new field with the difference(which in this case is 4mins)






excel







share|improve this question













marked as duplicate by Ron Rosenfeld, greg-449, Rob, Mark Rotteveel, Max Vollmer Nov 21 '18 at 15:43


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.














  • 2





    What have you researched / tried so far, and what problem / error did you experience?

    – Olly
    Nov 21 '18 at 11:20
















-3
















This question already has an answer here:




  • subtract datetime in excel

    2 answers




I have two fields having date and time like: 11/08/2018 12:04 and 11/8/2018 12:00. I want Excel to subtract these fields and return me a new field with the difference(which in this case is 4mins)






excel







share|improve this question













marked as duplicate by Ron Rosenfeld, greg-449, Rob, Mark Rotteveel, Max Vollmer Nov 21 '18 at 15:43


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.














  • 2





    What have you researched / tried so far, and what problem / error did you experience?

    – Olly
    Nov 21 '18 at 11:20














-3












-3








-3









This question already has an answer here:




  • subtract datetime in excel

    2 answers




I have two fields having date and time like: 11/08/2018 12:04 and 11/8/2018 12:00. I want Excel to subtract these fields and return me a new field with the difference(which in this case is 4mins)






excel







share|improve this question















This question already has an answer here:




  • subtract datetime in excel

    2 answers




I have two fields having date and time like: 11/08/2018 12:04 and 11/8/2018 12:00. I want Excel to subtract these fields and return me a new field with the difference(which in this case is 4mins)





This question already has an answer here:




  • subtract datetime in excel

    2 answers







excel




excel






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 21 '18 at 11:08









Sammy SinghSammy Singh

12




12




marked as duplicate by Ron Rosenfeld, greg-449, Rob, Mark Rotteveel, Max Vollmer Nov 21 '18 at 15:43


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.









marked as duplicate by Ron Rosenfeld, greg-449, Rob, Mark Rotteveel, Max Vollmer Nov 21 '18 at 15:43


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.










  • 2





    What have you researched / tried so far, and what problem / error did you experience?

    – Olly
    Nov 21 '18 at 11:20














  • 2





    What have you researched / tried so far, and what problem / error did you experience?

    – Olly
    Nov 21 '18 at 11:20








2




2





What have you researched / tried so far, and what problem / error did you experience?

– Olly
Nov 21 '18 at 11:20





What have you researched / tried so far, and what problem / error did you experience?

– Olly
Nov 21 '18 at 11:20












1 Answer
1






active

oldest

votes


















0














TEXT function can used to calculate time.



Assuming the date values are in A1 and A2



=TEXT(A1-A2,"h:mm:ss")






share|improve this answer






























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    TEXT function can used to calculate time.



    Assuming the date values are in A1 and A2



    =TEXT(A1-A2,"h:mm:ss")






    share|improve this answer




























      0














      TEXT function can used to calculate time.



      Assuming the date values are in A1 and A2



      =TEXT(A1-A2,"h:mm:ss")






      share|improve this answer


























        0












        0








        0







        TEXT function can used to calculate time.



        Assuming the date values are in A1 and A2



        =TEXT(A1-A2,"h:mm:ss")






        share|improve this answer













        TEXT function can used to calculate time.



        Assuming the date values are in A1 and A2



        =TEXT(A1-A2,"h:mm:ss")







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 21 '18 at 11:26









        Abhilash VishwakarmaAbhilash Vishwakarma

        11




        11















            -

            Popular posts from this blog

            "Incorrect syntax near the keyword 'ON'. (on update cascade, on delete cascade,)

            Image
            .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 2 total noob sorry any help greatly appreciated. I keep getting this "Incorrect syntax near the keyword 'ON'." heres my codes code one CREATE TABLE supplier ( supplierID INT PRIMARY KEY, ISBN INT FOREIGN KEY REFERENCES book(ISBN), price DECIMAL (5,2), ON UPDATE CASCADE, ON DELETE CASCADE, ); code two CREATE TABLE orders ( orderID INT PRIMARY KEY, customerID INT FOREIGN KEY REFERENCES customer(customerID), ISBN INT FOREIGN KEY REFERENCES book(ISBN), orderDate date, ON UPDATE CASCADE, ON DELETE CASCADE, ); Ive run out of stuff to try other than dumbing it down to uselessness. ...
            Read more

            Alcedinidae

            Image
            Alcedinidae Martin-pêcheur à dos bleu ( Alcedo azurea ) Classification (COI) Règne Animalia Embranchement Chordata Sous-embr. Vertebrata Classe Aves Ordre Coraciiformes Famille Alcedinidae Rafinesque, 1815 Les Alcédinidés ou Alcedinidae forment une famille d'oiseaux plus connus sous les noms de martins-pêcheurs et martins-chasseurs. Sommaire 1 Description 2 Répartition et habitat 3 Systématique 3.1 Liste alphabétique des genres 3.2 Liste des espèces 4 Chez les Anciens : l'alcyon 4.1 Étymologie (Littré) 4.2 Oiseau « fabuleux » ? 5 Notes 6 Articles connexes 7 Liens externes 7.1 Bibliographie Description | Ce sont des oiseaux compacts de taille petite à moyenne (10 à 46 cm), au bec droit et long, en forme de poignard. Leurs pattes sont courtes, et ils portent un plumage aux couleurs vives. Répartition et habitat | Cosmopolites, ils fréquentent surtout ...
            Read more

            Origin of the phrase “under your belt”?

            Image
            .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0; } 17 1 Today, I found myself discussing what students should have "under their belts" during a lecture, and I wondered to myself if there was some inappropriate undertone here that I might be unaware of. Question : What is the origin of the phrase "under your belt"? A google search revealed some webpages (e.g. [1]) that assert its origin is related to consumption of food -- once a meal has been eaten, it's under your belt (which is a relief). However, with such websites, I have no way to determine fact from "random guy on the internet making stuff up". etymology idioms ...
            Read more