Always Rounding Time Up

[biggles1212]

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

 

[comment]

Try =

Ceiling ( Timefield / 3600 ) * 3600

[biggles1212]

Thanks!

[Lee Smith]

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?

[biggles1212]

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.

[Lee Smith]

I’m curious, does Compensation time equal

1 min 30 sec = 1 min 30 sec

or  

1 min 30 sec = 1 hour?

[biggles1212]

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.

[Rick Whitelaw]

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