Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Feb 2003
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Offset time by -4 hours (Excel 2000/SR-1)

    Many of you will find this to be very simple, but it has me stumped! In a spreadsheet, in one column I have a time value, and in the adjacent column I want it adjusted by minus 4 hours to give me the Eastern Std Time. e.g if I have 19:42:40 in the time column, to its right I want the column to display 3:42:40 pm (which is 19:42:40 -4 = 15:42:40). How do I do this (simple) task?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Offset time by -4 hours (Excel 2000/SR-1)

    If you have your first timevalue in A1 (format h:mm:ss) , then in B1 the following formula will give you the answer you want :-<pre> =A1 - TIME(4,0,0)</pre>

    You should have B1 formatted as h:mm:ss AM/PM

    Andrew C

  3. #3
    Star Lounger
    Join Date
    Feb 2003
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Offset time by -4 hours (Excel 2000/SR-1)

    Thanks, Andrew. It works perfectly - just what I wanted!

Posting Permissions

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