+ Reply to Thread
Results 1 to 2 of 2

How can I show time spent?

  1. #1
    L
    Guest

    How can I show time spent?

    In an Excel worksheet, I have 2 columns, 'start' and 'end' time; in the 3rd
    column, I need to show time spent on a task. I'm sure this can be done, just
    not sure how...any suggestions would be appreciated, thanks.

    L

  2. #2
    Forum Expert
    Join Date
    09-09-2005
    Location
    England
    MS-Off Ver
    2007
    Posts
    1,500
    Just subtract the start time from the finish time
    eg if start in a3 and finish in b3

    b3-a3 then copy down to the other cells

    format the cells as custom and type the following [hh]:mm

    regards

    Dav

+ 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