Link to home
Start Free TrialLog in
Avatar of fjkilken
fjkilken

asked on

Round up/down seconds to nearest 30 secs in Excel

Hi
I have multiple finish times for athletes so would like to round them up/down to the nearest 30 secs in Excel.
eg; 07:01:28 I would like to roundup to 07:01:30
eg; 07:01:49 I would like to roundup to 07:02:00

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of jppinto
jppinto
Flag of Portugal 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
Avatar of fjkilken
fjkilken

ASKER

perfect - very nice - I am going to try play with the formula to attempt rounding to the nearest 15 seconds