Link to home
Start Free TrialLog in
Avatar of UniqueData
UniqueDataFlag for United States of America

asked on

Round caluclated difference to nearest quarter hour

I have found functions here that round a time (such as 3:12pm) to the nearest quarter hour, however, I can't find anything to round a calculated difference to the nearest quarter hour.

I have total time in minutes that someone has worked on a project.  I need turn it into hours (rounding to the nearest qtr hour)

For example:  130 minutes = 2.25 hr
ASKER CERTIFIED SOLUTION
Avatar of Yveau
Yveau
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Sorry, forgot the result:

---------------------------------------
2.25

...
Avatar of UniqueData

ASKER

awesome.

Thanks
Glad I could be of any help and thanks for the grade !