#1
|
|||
|
|||
MROUND funtion
I have a spread sheet that tracks benifit time for employees.
I need it to round to the nearest 15. Been trying to incorperate the MROUND function but not having any luck. The formula in the cell is =IF(F108="","",MIN(40,C108+E108-F108)). This adds any time earned and subtracts time used and tops out at 40, but our time clock works on 15 minute interavals. Hopefully I have attached the file. Any insite would be gratly appreciated. Thanks, |
#2
|
||||
|
||||
if the numbers involved are minutes then:
=IF(F108="","",MROUND(MIN(40,C108+E108-F108),15)) It they're hours then: =IF(F108="","",MROUND(MIN(40,C108+E108-F108),0.25)) unless, that is, you want to do the rounding of the individual numbers first. |
#3
|
|||
|
|||
Thanks works great!!!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Brush Colour Funtion in PowerPoint 2013 | rbiermann | PowerPoint | 7 | 11-03-2013 02:09 PM |
Is the broadcast funtion of ppt. broken? | CLW | PowerPoint | 1 | 10-31-2013 01:21 PM |
Outlook 2003 agenda shearh funtion | Joostdegrote | Outlook | 0 | 09-23-2010 03:12 AM |