biggles1212 Posted February 2, 2015 Share Posted February 2, 2015 I have a time field which I need to work out firstly is it over 10 hours and if it is I need it rounded to the nearest hour. A simple IF statement helped me with the first part. The second part however I am not sure about. ie. 10:59:22 ~ 11:00:00 10:01:30 ~ 11:00:00 Link to comment Share on other sites More sharing options...
comment Posted February 2, 2015 Share Posted February 2, 2015 Try = Ceiling ( Timefield / 3600 ) * 3600 1 Link to comment Share on other sites More sharing options...
biggles1212 Posted February 2, 2015 Author Share Posted February 2, 2015 Thanks! Link to comment Share on other sites More sharing options...
Lee Smith Posted February 2, 2015 Share Posted February 2, 2015 I have a time field which I need to work out firstly is it over 10 hours and if it is I need it rounded to the nearest hour 10:01:30 ~ 11:00:00 Are you really going to charge for an hour if you go over 10 hours by 1 min and 30 secs? Link to comment Share on other sites More sharing options...
biggles1212 Posted February 5, 2015 Author Share Posted February 5, 2015 As crazy as that sounds no, it is actually for a duty roster tracking purpose. If the staff member goes over 10 hours of work (plus any part of an hour) they need to have x amount of time off. Link to comment Share on other sites More sharing options...
Lee Smith Posted February 5, 2015 Share Posted February 5, 2015 I’m curious, does Compensation time equal 1 min 30 sec = 1 min 30 sec or 1 min 30 sec = 1 hour? Link to comment Share on other sites More sharing options...
biggles1212 Posted February 23, 2015 Author Share Posted February 23, 2015 Any hour past 10 hours or there part of i.e 1 minute and 30 seconds of duty over 10 hours would be 11 hours. I think any reasonable employee would just call it 10 hours of work rather than creating an inquiry of questions and time spent on why they logged an extra second. Link to comment Share on other sites More sharing options...
Rick Whitelaw Posted February 23, 2015 Share Posted February 23, 2015 If this time is registered by a punch clock or card swipe the employee is not afforded the opportunity to be reasonable. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3349 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