1 2 3 Previous Next 37 Replies Latest reply on Jun 16, 2017 4:51 AM by fmpdude

    Calculating with time in calculated fields

    mz5005

      I have a table with time in GMT (Greenwich Mean Time;  +0 hours) in a field type TIME. I need to recalculate the time to GMT+2, so I have made a calculated field for that "GMT_field +2". The Help states that FMP considers digits as hours:

       

      Counting with Time 1.PNG

      However, if I calculate the 00:00:00 time i get just "2" and 01:00:00 leads to 3602 (3600 secs for an hour).

       

      Q1: Been hassling around with GetAsTime(), but can't get it right. Anyone?

       

      Q2: if time passes 22:00, I need to change the date also of course. How do you do that in a calculated field based on the values of the 2 other fields (date and GMT)?

       

      As always any help greatly appreciated!

       

      GMT_plus_2.PNG

        1 2 3 Previous Next