Page 1 of 1

Midnight

PostPosted: Thu Oct 26, 2017 11:16 am
by denismailloux
Hello!

I let this one behind me for the last year but today I want to understand...

You are always correcting TimeStart and TimeEnd in order to add 1 second to the time value when the hour is exactly midnight (and each multiple of 24 hours). Why is it necessary? I'm using this system to calculate payroll and 1 second more is not acceptable. It makes silly calculation...

I would probably need to avoid this correction and let 00:00:00 be 00:00:00, but before I do some testing, I would like to listen to you. Is it related to DayBack calendar?

Thanks!

Denis

Re: Midnight

PostPosted: Thu Oct 26, 2017 1:12 pm
by kcembrey
Hi Dennis,

Yes, the calculations that we have in the TimeStart and TimeEnd fields are required so the events show up correctly on the calendar.

Here's a quick video I made of a couple options that use an additional FileMaker field for your timecard start and end times that should work for you: https://seedcodevideos.s3.amazonaws.com ... 0-2017.mp4

Let me know if that helps!

Thanks,

KC