October 25, 200322 yr Newbies I'm VERY new to FMP. Is there a TIMER function? I'd like to make a database form (new to the terminology) that has Start; Stop; Resume; and Reset buttons; that shows the time in HH:MM:SS format, as well as in 1/10's of an hour (or other increment that I desire). Also, I'd like the 'time' to be such that it can be 'added' or 'subtracted' from other values, so I could see how much total time was spent (in 1/10's of hours, as well as HH:MM:SS). Also, a 'round up' function would be nice, so 3 mintues 44 seconds yields .1 hour; 6 minutes 12 seconds yields .2 hours; etc. I imagine many would find this helpful, so as full of an explanation as possible would be GREATLY APPRECIATED!
October 25, 200322 yr You'll have to use the Status(CurrentTime) function to get the current time and store that in separate time fields. Time fields can be be 'added' or 'subtracted' at will. Als when you enter a time value in a number field, it automatically gets converted to an amount of seconds, so you can thn divide it into whatever increments you want with some more calculations... Regards, Ernst.
October 25, 200322 yr To round up and down time values, see this thread: http://www.fmforums.com/threads/showflat.php?Cat=&Number=47932&page=7&view=collapsed&sb=5&o=all&fpart=1
Create an account or sign in to comment