+ Reply to Thread
Results 1 to 2 of 2

template or formula for start time -finish time -total hours ple

  1. #1
    cc
    Guest

    template or formula for start time -finish time -total hours ple

    please could I have a formula or function to enter start time-end time and
    show total hours/mins for excel

  2. #2
    Peo Sjoblom
    Guest

    Re: template or formula for start time -finish time -total hours ple

    =B1-A1

    =B1-A1+(A1>B1)

    =MOD(B1-A1,1)


    with start time in A1 and end in B1 using excel time format hh:mm:ss

    the first 2 formulas work if start is before and end is after midnight


    --

    Regards,

    Peo Sjoblom
    "cc" <cc@discussions.microsoft.com> wrote in message
    news:CD5F3A3B-7101-441C-A18A-93DE69C2D31C@microsoft.com...
    > please could I have a formula or function to enter start time-end time and
    > show total hours/mins for excel




+ 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