|
|
#1
10-26-2018, 11:58 AM
|
|||
|
|||
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, 
|
|
|
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 |
Windows 7 32bit 
Office 2007
Threaded Mode