+ Reply to Thread
Results 1 to 5 of 5

calculating total time

  1. #1
    Registered User
    Join Date
    03-08-2006
    Posts
    28

    calculating total time

    I have two fields "start time" and "end time" for tracking my time on projects. on each line next to those fields i'd like to add a "total" field that automatically calculates the total time in hours and minutes. I thought there might be a function for this already, but i'm not finding it in the help files...any suggestions?

  2. #2
    Forum Contributor
    Join Date
    08-28-2005
    Posts
    285

    calculating total time

    hi!

    in C1:

    =B1-A1

    where endtime & start time in B1 & A1 respectively
    and format C1 Custom > [hh]:mm

    -via135



    Quote Originally Posted by bcamp1973
    I have two fields "start time" and "end time" for tracking my time on projects. on each line next to those fields i'd like to add a "total" field that automatically calculates the total time in hours and minutes. I thought there might be a function for this already, but i'm not finding it in the help files...any suggestions?

  3. #3
    Peo Sjoblom
    Guest

    Re: calculating total time

    Times in excel is just numbers so to get total time jus subtract

    =B1-A1

    where A1 is start and B1 end, if more than 24 hours use a custom format of

    [hh]:mm


    --

    Regards,

    Peo Sjoblom

    http://nwexcelsolutions.com


    "bcamp1973" <bcamp1973.27i2cy_1147110301.1269@excelforum-nospam.com> wrote
    in message news:bcamp1973.27i2cy_1147110301.1269@excelforum-nospam.com...
    >
    > I have two fields "start time" and "end time" for tracking my time on
    > projects. on each line next to those fields i'd like to add a "total"
    > field that automatically calculates the total time in hours and
    > minutes. I thought there might be a function for this already, but i'm
    > not finding it in the help files...any suggestions?
    >
    >
    > --
    > bcamp1973
    > ------------------------------------------------------------------------
    > bcamp1973's Profile:
    > http://www.excelforum.com/member.php...o&userid=32268
    > View this thread: http://www.excelforum.com/showthread...hreadid=539940
    >




  4. #4
    Biff
    Guest

    Re: calculating total time

    Hi!

    Just subtract the start time from the end time:

    A1 = start time = 7:30 AM
    B1 = end time = 5:45 PM

    Format the cell as [h]:mm

    =B1-A1

    Returns 10:15

    If the times might span past midnight use this formula:

    A1 = start time = 10:00 PM
    B1 = end time = 3:20 AM

    =B1-A1+(B1<A1)

    Returns 5:20

    Biff

    "bcamp1973" <bcamp1973.27i2cy_1147110301.1269@excelforum-nospam.com> wrote
    in message news:bcamp1973.27i2cy_1147110301.1269@excelforum-nospam.com...
    >
    > I have two fields "start time" and "end time" for tracking my time on
    > projects. on each line next to those fields i'd like to add a "total"
    > field that automatically calculates the total time in hours and
    > minutes. I thought there might be a function for this already, but i'm
    > not finding it in the help files...any suggestions?
    >
    >
    > --
    > bcamp1973
    > ------------------------------------------------------------------------
    > bcamp1973's Profile:
    > http://www.excelforum.com/member.php...o&userid=32268
    > View this thread: http://www.excelforum.com/showthread...hreadid=539940
    >




  5. #5
    Registered User
    Join Date
    03-08-2006
    Posts
    28

    Thank you!

    Perfect, thanks everyone!

+ 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