Find the answer to your Linux question:
Results 1 to 3 of 3
Is there a formula in OO.o Calc for calculating the difference in time between to dates with hours and minutes? My examples are: What is the time differencve between 11hrs ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Nov 2006
    Posts
    35

    Time Difference Days, Hours, Minutes


    Is there a formula in OO.o Calc for calculating the difference in time between to dates with hours and minutes?

    My examples are:

    What is the time differencve between 11hrs 00Mins on 08/11/2007
    AND 17:30 on 09/11/2007 (Day, Month,Year)

    Thanks in advance

    Tony Littlejohn

  2. #2
    Linux Engineer RobinVossen's Avatar
    Join Date
    Aug 2007
    Location
    The Netherlands
    Posts
    1,429
    I dont know about OOo since I just dont want to use it.
    But you can try to first change the time to a UnixTime-Stamp
    then do Stamp1-Stamp2 and then check the Diffrence.
    Thats Easy
    New Users, please read this..
    Google first, then ask..

  3. #3
    Just Joined!
    Join Date
    Nov 2006
    Posts
    35
    Many thanks for the pointer Robin. The last time ( no pun intended) that I did this sort of stuff I was using a DOS app called Framework III with a language called FRED. You had a function called DiffDate which solved these problems in a jiffy.

    Thanks again,

    Tony

Posting Permissions

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