UniqueData
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
awesome.
Thanks
Thanks
Glad I could be of any help and thanks for the grade !
--------------------------
2.25
...