Search the Community
Showing results for tags 'time'.
-
Hello, I am trying to get Scribe360 to import time values (e.g 08:00) from Excel to Filemaker. In Excel the cells are formatted as hh:mm. In Filemaker I have defined the field as time but instead of getting 08:00, I get 00:00:8 which is wrong. In addition, when I try and format the fi...
-
After voting up the 'Time Picker' suggestion in Filemaker's new Product Ideas, I thought perhaps I could just simplify the method of input without a picker and without punctuation. - enter times using only numbers. - AM/PM is determined by the Workday Starting Hour. - use punctuation to ov...
-
We have users syncing using laptops all over different timezones. However, there is the possibility that the laptop's time/zone are not set to automatically update and either can be set incorrectly. Moreover, we cannot rely on any internet access. So, a user may travel from Rome to Moscow and never...
-
Hi First of all I have only just started experimenting with MirrorSync and overall it's a pretty slick product. One issue I have come across is that my spoke database (on ipad) is showing time fields with values 1 hour ahead of the values in the hub database. When I connect directly to the hub fr...
-
Hi, Since I could not use 10ths of seconds in FMP I’ve been converting the time and presenting it this way [Time*24**60*60]. This is fine by me, but I suppose some users might not care for it. Is there a way to reverse this in FMP — to take, i.e., 73.3 and get back 1:13.3 or 1.13.3? Thanks, Pa...
-
I'm having a lot of trouble figuring out how I should be formatting a Time for input into a field. How should I do this? I was able to input a date by taking a date with the format MM-DD-YYYY and putting it through date() and setting a date field to that, but I can not for the life of me get time to...
-
(My first post to this forum - if I've misplaced this question please let me know and I'll happily move to a more appropriate folder.) Â I'm trying to build a database that I can use to log video footage. I've a system that seems to be working for me so far, but there's a couple of tools that wou...
-
Hello! I've Mac OS 10.6.8 with FM 5.5v1 (yes, I know I need to upgrade but bare with me on this one): I have a field named "Duration" that indicates time duration in hours, minutes and seconds, example: 0:32:11 That means 0 hours, 32 minutes and 11 seconds. I want to c...
-
Hi guys, I've been searching through the forums here to get some insight into a problem I've been having, but I can't quite find enough info to figure it out. I have a FileMaker solution that tracks time spent on a job. Each job can have multiple time entries logged for it, and since a few p...
- 10 replies
-
- calculation
- time
-
(and 4 more)
Tagged with: