![]() |
|
#1
|
||||
|
||||
![]()
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. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
rbiermann | PowerPoint | 7 | 11-03-2013 02:09 PM |
![]() |
CLW | PowerPoint | 1 | 10-31-2013 01:21 PM |
Outlook 2003 agenda shearh funtion | Joostdegrote | Outlook | 0 | 09-23-2010 03:12 AM |