BR
asked on
Excel simple formula
How can I round up time ( I have hours and minutes )
I want 14:32 to round up 15:00
I want 14:32 to round up 15:00
=TIME(HOUR(A1),0,0)
=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
=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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.