Jump to content
Sign in to follow this  
biggles1212

Always Rounding Time Up

Recommended Posts

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

 

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

I’m curious, does Compensation time equal

1 min 30 sec = 1 min 30 sec

or  

1 min 30 sec = 1 hour?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

If this time is registered by a punch clock or card swipe the employee is not afforded the opportunity to be reasonable.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.