Hi
I have a list of times and some of them are - ie 9:59:59AM.
To put my list into a pivot table and make some sense of I need to round the times that are ending in 59...
Ive tried many things but cannot get it to work..
Can someone help.
Thanks
Leigh
A time value is a value from 0-1. 0 being 00:00:00 and 1 being 24:00:00.
Would you like to round in minutes (No seconds) ? per 15 minutes, 30 minutes, 1 hour ?
Per 15 minutes: =FLOOR($A1+"0:15"/2,"0:15")
Last edited by rwgrietveld; 03-04-2010 at 07:05 AM.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
Thanks a lot... worked perfect..!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks