View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bushman Bushman is offline
external usenet poster
 
Posts: 2
Default How can I change time format to decimal without losing hours?

I am trying to enter a time of 33:13:00 and get a display of a decimal of
33.21. If I format the box to be decimal when I enter the time it does not
give the full 33 hours but in turn replaces it with 1.38. Is there are
function or formula that will allow the user to type in the time in hours and
minutes to convert it to a decimal format?