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

 

Try =

Ceiling ( Timefield / 3600 ) * 3600

Thanks!

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?

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.

I’m curious, does Compensation time equal

1 min 30 sec = 1 min 30 sec

or  

1 min 30 sec = 1 hour?

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.

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