View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] sygibson@gmail.com is offline
external usenet poster
 
Posts: 1
Default Convert floating point to Hours and Minutes ??

Hello all - I would like to convert a floating point number (eg 3.25)
to Hours and Minutes (eg 3:15). I've been poking and prodding at this
for quite a long time, and can't find a solution. Does anyone have a
fast and dirty trick for doing this?

Essentially, I have a spreadsheet that does a bunch of time
calculations based on speed and distance. Once I've done that, I'd
like to convert the finished notation into a time value.

I'm using Excel 2002. Thank you any and all for your insights or help.