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:
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!