wattmhite Posted June 22, 2017 Share Posted June 22, 2017 There may be a simple solution to this but I can't think of one. I have a field that calculated total hours for the day. How can I have a field show any time over 8 hours for that day? Thanks Link to comment Share on other sites More sharing options...
Lee Smith Posted June 22, 2017 Share Posted June 22, 2017 This question comes up from time to time. See if this helps https://www.google.com/search?client=safari&rls=en&q=site:+fmfourms.com&ie=UTF-8&oe=UTF-8#q=site:+fmforums.com+overtime HTH Lee Link to comment Share on other sites More sharing options...
comment Posted June 22, 2017 Share Posted June 22, 2017 2 hours ago, wattmhite said: I have a field that calculated total hours for the day. Is the result type Time? If yes, you can do: Max ( TotalHours - Time ( 8 ; 0 ; 0 ) ; 0 ) The result is Time, too. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2492 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now