I'm wondering if there's a way to convert a number to reflect a time. For example, if a number is 9.75 I would want the formula to convert it to 9:45. If the number was 9.47 I'd want the formula to make it 9:28. Obviously the numbers go from .00 to .99 while the time only goes from :00 to :59. Thanks in advance for any help
Assuming "decimal time" is in A1 AND you're using a 24 hour "decimal time" (meaning 13.5 = 1:30 PM), use:
=A1/24
and format the cell you put the formula in as a Time.
- Clay Ver Valen
Excel Help
Last edited by clayv; 09-21-2006 at 02:45 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks