Ampleford
Active Member
- Joined
- Mar 26, 2002
- Messages
- 380
I have a spreadsheet which calculates and shows peoples attendance times. However, the "Total Time Worked" column (say Column B) shows 07:55 hrs or 08:13 hrs. I'd like to round it so that if they do (up to) three minutes into a quarter, then it rounds down, but if they do more than three minutes into a quarter, it rounds up to the next quarter hour.
eg - Employee A works 08:03 hours = Paid 8.00, Employee B works 08:04 hours = Paid 8.25
Can anyone assist me?
eg - Employee A works 08:03 hours = Paid 8.00, Employee B works 08:04 hours = Paid 8.25
Can anyone assist me?