Thread: Excel Help
View Single Post
Old 16-04-2009, 20:22   #3
cookie_365
Inactive
 
cookie_365's Avatar
 
Join Date: Mar 2004
Location: Brighton
Posts: 2,583
cookie_365 is cast in bronzecookie_365 is cast in bronzecookie_365 is cast in bronzecookie_365 is cast in bronze
cookie_365 is cast in bronzecookie_365 is cast in bronzecookie_365 is cast in bronzecookie_365 is cast in bronzecookie_365 is cast in bronzecookie_365 is cast in bronzecookie_365 is cast in bronzecookie_365 is cast in bronzecookie_365 is cast in bronzecookie_365 is cast in bronzecookie_365 is cast in bronzecookie_365 is cast in bronzecookie_365 is cast in bronzecookie_365 is cast in bronzecookie_365 is cast in bronzecookie_365 is cast in bronzecookie_365 is cast in bronze
Re: Excel Help
I'm sure there are more elegant ways, but

Code:
=ROUND(((A1*60)+B1)/60,0)
where A1 is the hours and B1 the minutes should do it.
cookie_365 is offline   Reply With Quote