Excel simple formula

How can I round up time ( I have hours and minutes )
I want 14:32 to round up 15:00
LVL 1
BRMarketingAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Sorry I should have had

=TIME(HOUR(A1)+1,0,0)
0
 
Saqib Husain, SyedEngineerCommented:
=TIME(HOUR(A1),0,0)
0
 
ddiazpCommented:
=ROUND(A1*24/0.5 ,0)*0.5 /24 - to round up every 30 mins

=ROUND(A1*24/0.5 ,0)*0.25 /24 - to round up every 15 mins

=ROUND(A1*24/0.5 ,0)*0.05 /24 - to round up every 3 mins


Don't forget the [hh]:mm formatting
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.