Jump to content

Always Rounding Time Up


This topic is 1993 days old. Please don't post here. Open a new topic instead.

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

 

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?

Link to post
Share on other sites
  • 3 weeks later...

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 post
Share on other sites

This topic is 1993 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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

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