AnsweredAssumed Answered

Calculating with time in calculated fields

Question asked by mz5005 on Jun 13, 2017
Latest reply on Jun 16, 2017 by fmpdude

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

Outcomes