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!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER