Can anyone advise on how to round times to the nearest 10 seconds? I am using hh:mm:ss time format in Excel 2003. For example:
12:00:54 should be 12:00:50
02:50:50 should be 02:50:50 (i.e. this one is fine)
17:40:46 should be 17:40:50
08:30:42 should be 08:30:40
23:20:38 should be 23:20:40
The example shows rounding up for numbers 5 to 9 and rounding down for 1-4 but it would be OK to round them all up or down if that is easier.
Many thanks
Last edited by menos; 07-06-2011 at 04:22 AM.
Maybe like this:
=time(hour(A1),minute(A1),round(second(A1)/10,0)*10)
That works great, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks