Results 1 to 3 of 3

Thread: Time Calculation

  1. #1

    Time Calculation



    Register for a FREE account, and/
    or Log in to avoid these ads!

    well imagine bellow given times are the ones that i need to get the deference...
    in
    A1 = 17235.36
    A2 = 3458.48

    in A3 i need A1 - A2. But my problem is I just can't deduct A2 from A1 right ? So how to calculate that time difference ?

    Pleeeeeeeease help me

  2. #2
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    yep go right ahead and subtract.
    1 day = 1, so hours = 24 x difference.
    You may want to format it to give the result type you expecting.
    Or could use dateDiff function

    If A1 are in seconds then same logic and divide by 24 / 60 / 60 to get into Excel date format

  3. #3
    A1 & A2 your data
    Format A3 as d/mm/yyyy h:mm and formula =MAX(A1,A2)-MIN(A1,A2)
    Using your data result is 18/09/1937 21:07 , if only time required change format to h:mm

Posting Permissions

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