+ Reply to Thread
Results 1 to 2 of 2

Time conversion formula

Hybrid View

  1. #1
    Registered User
    Join Date
    07-22-2010
    Location
    USA
    MS-Off Ver
    2010
    Posts
    24

    Time conversion formula

    [solved]
    Cell $A$2 contains a date Formatted 3/11/2013 1:30 PM which is the target GMT
    Cell A5 contains the hours difference from GMT number ## can be 5 or -5
    Cell a9 contains a number from .01 to 24 that is hours format number ##.##

    I need a formula that take a2 and adds a5 and subtracts a9 and gives an answer in time Formatted 3/11/2013 1:30 PM

    if a2 = 3/11/2013 1:30 PM
    if A5 = 5
    and a9 = .25
    then 1:30 +5 -.25 = 3/11/2013 6:15 PM

    If a9 = 19 then = 1:30 +5 -19 = 3/10/2013 11:30 PM

    TY
    Last edited by Cbrehm; 06-19-2013 at 12:50 PM. Reason: solved

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Time conversion formula

    Maybe..

    =A2+(A5-A9)/24
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ 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