Re: $$Excel-Macros$$ Convert numbers into HH:MM:SS

2012-10-06 Thread David Grugeon
Sorry should be In B1 put = A1*100/24/60 Regards David Grugeon On 7 October 2012 10:06, David Grugeon wrote: > GOTTIT > > the 2.5 is in units of 100 minutes > > In B1 put = A1*100/24 > Format B1 as hh:mm:ss > > > Regards > David Grugeon > > > On 7 October 2012 03:42, santosh subudhi > wr

Re: $$Excel-Macros$$ Convert numbers into HH:MM:SS

2012-10-06 Thread David Grugeon
GOTTIT the 2.5 is in units of 100 minutes In B1 put = A1*100/24 Format B1 as hh:mm:ss Regards David Grugeon On 7 October 2012 03:42, santosh subudhi wrote: > Hi Group, > > I want to convert numbers into hrs and mins. > > Suppose if I enter 2.5 in Cell A1 it should automatically convert i

Re: $$Excel-Macros$$ Convert numbers into HH:MM:SS

2012-10-06 Thread Paul Schreiner
people you can, As long as ever you can.” - John Wesley - From: santosh subudhi To: excel-macros Sent: Sat, October 6, 2012 1:43:09 PM Subject: $$Excel-Macros$$ Convert numbers into HH:MM:SS Hi Group, I want to

$$Excel-Macros$$ Convert numbers into HH:MM:SS

2012-10-06 Thread santosh subudhi
Hi Group, I want to convert numbers into hrs and mins. Suppose if I enter 2.5 in Cell A1 it should automatically convert it into HH:MM:SS ie 4:10:00 in cell B1 -- Regards Santosh santoshkumar.subu...@gmail.com -- Join official facebook page of this forum @ https://www.facebook.com/discussexce