Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Oct 2008
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

    In column A I have the starting day/time stamp. In Column B I have the ending day/time stamp. For example:

    Starting | Ending
    000/00:35:00 | 001/19:45:00
    000/00:35:00 | 008/00:45:00

    In column C I want to get the time difference in hours between the ending and starting day/time stamp. Any idea how to accomplish this?

    Thanks.

    BTW: How do you put a 'tab' between headings in this communication dialog?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    See the attached sample workbook; it uses intermediate formulas to calculate the difference.

    BTW it would be easier if columns A and B contained regular date+time values.

    PS You can't insert tab characters in a post. You can use the [code] ... [/code] tags to create fixed-width text in a post:

    Code:
    Starting	  Ending
    000/00:35:00  001/19:45:00
    000/00:35:00  008/00:45:00

  3. #3
    2 Star Lounger
    Join Date
    Oct 2008
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='774364' date='08-May-2009 15:12']See the attached sample workbook; it uses intermediate formulas to calculate the difference.

    BTW it would be easier if columns A and B contained regular date+time values.

    PS You can't insert tab characters in a post. You can use the [code] ... [/code] tags to create fixed-width text in a post:

    Code:
    Starting	  Ending
    000/00:35:00  001/19:45:00
    000/00:35:00  008/00:45:00
    [/quote]

    Thanks Hans, but where is the attached workbook?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Oops, sorry. Here it is.
    Attached Files Attached Files

  5. #5
    2 Star Lounger
    Join Date
    Oct 2008
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='774366' date='08-May-2009 15:18']Oops, sorry. Here it is.[/quote]
    Much appreciated.

Posting Permissions

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