Thread: Convert
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dallas Colt Dallas Colt is offline
external usenet poster
 
Posts: 2
Default Convert

aghhh...I just figured that out, thank you. How do I take the single cell
and transfer it into Hours in one cell and minutes in the other for 2.58??
Again, thank you for your help. We have a time sheet that doesn't export it
into hours and minutes.
--
Dallas


"jhyatt" wrote:

where is 2.97 coming from decimel time time would put that at 2 hours 58 mins

"Dallas Colt" wrote:

How do I convert a cell showing 2.97 into 3 hours and 37 minutes and place 3
in one column and 37 in the other column...make sense???
--
Dallas