[Solved] How to Round minute column

DOUGHBOYONE · Post by **DOUGHBOYONE** » Mon May 30, 2011 8:25 pm

Calc, Beginner, Personal use, wants to Round minute column:
I need to round cells entered in minutes:
to nearest quarter hour.
I am searching all my resources try to solve this

Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply (Hagar, Moderator).

edit this topic's initial post · Post by **Villeroy** » Mon May 30, 2011 8:26 pm

=MROUND(A1;1/96)

DOUGHBOYONE · Post by **DOUGHBOYONE** » Mon May 30, 2011 10:34 pm

"=MROUND(A3/60;0.25)" this formula seems to work converting minutes to hours to the nearest quarter hour, where A1= any number of minutes

i tried "=MROUND(A1;1/96), but i kept getting the exact number that was in A1

Richarda44 · Post by **Richarda44** » Tue May 31, 2011 11:38 am

The reason you got the same number is that A1 did not contain a special "time" number. You did say originally it was a "minute" collumn, not an ordinary number collumn

DOUGHBOYONE · Post by **DOUGHBOYONE** » Wed Jun 01, 2011 2:39 am

ic, tks, yes when i add up my wait time it is just regular number, ex: 113 then i must convert to the number hours to nearest quarter hour, ex: 2.0 hours * houtly rate

[Solved] How to Round minute column

[Solved] How to Round minute column

Re: Calc, Beginner, Personal use, wants to Round minute colu

Re: How to Round minute column

Re: [Solved] How to Round minute column

Re: [Solved] How to Round minute column