+ Reply to Thread
Results 1 to 2 of 2

Adding subtracting times

  1. #1
    Registered User
    Join Date
    03-23-2009
    Location
    Clever, Mo
    MS-Off Ver
    Excel 2003
    Posts
    3

    Adding subtracting times

    I am trying to add and substract start times and need a little help. I have it formatted so the user can enter the numbers without entering the colon. Here is the problem:

    start :30
    stop 1:55
    start 3:00
    stop 3:45
    Total run 1:70


    I have the cells formated, ##":", so the user can enter 0030 and get :30. So then I want to find the total run, I get 1:70. How can I get it cnverted to a time format?

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: Adding subtracting times

    try
    =time(hours,minutes,second)

    don't know if this is your expected result.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1